MSSQL – table name as a variable


declare @schema varchar(50)
declare @table varchar(50)
declare @query nvarchar(500)

set @schema = 'dbo'
set @table = 'ACTY'

set @query = 'SELECT * FROM [DB_ONE].[' + @schema + '].[' + @table + '] '

EXEC sp_executesql @query

source: https://stackoverflow.com/questions/2838490/a-table-name-as-a-variable

This entry was posted on Thursday, September 9th, 2021 at 7:42 pmand is filed under MSSQL Database Development. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.

Comments are closed.