April 14, 2011

To Run Dynamic Query in SQL Server

SET @SQLString = N'SELECT @TDATA=COUNT(*) FROM '+@QName

EXEC sp_executesql
@query = @SQLString,
@params = N'@TDATA INT OUTPUT',
@TDATA = @TDATA OUTPUT

No comments:

Post a Comment