The Tech Pursuit
The Dev Shelf
Pages
Home
Interview Questions
About Me
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment