17 jun 2010

Generate Sql queries on the fly

BEGIN
DECLARE @TableName as nvarchar(50),@test as nvarchar(max)
SET @TableName = 'orders'
Print @TableName
SET @test = 'SELECT * FROM ' + @TableName
EXEC(@test)
END

Geen opmerkingen:

Een reactie posten