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