I think your best bet is to use dynamic SQL to accomplish this:

create procedure myprocedure
@tableName varchar(50) = ''
as

    declare @sql_cmd = 'select blah from ' + QUOTENAME(@tableName) + ' where blah = blah2'
    
    exec (@sql_cmd)

go

I think your best bet is to use dynamic SQL to accomplish this:

create procedure myprocedure
@tableName nvarchar(50) = ''
as

    declare @sql_cmd nvarchar(200) 
    set @sql_cmd = 'select blah from ' + QUOTENAME(@tableName) + ' where blah = blah2'
    
    exec (@sql_cmd)

go

I think your best bet is to use dynamic SQL to accomplish this:

create procedure myprocedure
@tableName varchar(50) = ''
as

    declare @sql_cmd = 'select blah from ' + @tableName + ' where blah = blah2'
    
    exec (@sql_cmd)

go

I think your best bet is to use dynamic SQL to accomplish this:

create procedure myprocedure
@tableName varchar(50) = ''
as

    declare @sql_cmd = 'select blah from ' + QUOTENAME(@tableName) + ' where blah = blah2'
    
    exec (@sql_cmd)

go