The Tech Pursuit
The Dev Shelf
Pages
Home
Interview Questions
About Me
April 14, 2011
To make dynamic statement in SQL Server
SET @SQLString = 'UPDATE TOP('+CAST((@DISTROCOUNT+@REMDER) AS NVARCHAR(30))+')'+@QName+' SET UserID = '+@USERID+' WHERE UserID IS NULL'
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment