ROWCOUNT is pretty cool.
SET ROWCOUNT 5 --This limits not just SELECT but EXEC return…
2009-04-30
ROWID for T-SQL
Place this in your output:
If you add this code using [SVN](in this case a static subversion number) it will add a rowid - uniquely identifying sequential number to your output.
DECLARE @RUN_PARMS TABLE ( [SVN] VARCHAR(04) ... INSERT INTO @RUN_PARMS SELECT '1362' AS SVN ... SELECT ROW_NUMBER() OVER(PARTITION BY [SVN] ORDER BY [SVN]) AS ROWID , RP.[SVN] ...
If you add this code using [SVN](in this case a static subversion number) it will add a rowid - uniquely identifying sequential number to your output.
Subscribe to:
Posts (Atom)