2009-04-30

T-SQL limit SP return(for testing)

ROWCOUNT is pretty cool.

SET ROWCOUNT 5 --This limits not just SELECT but EXEC return…

ROWID for T-SQL

Place this in 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.

Cnt.hta_




Example of...



-Page based CSS style

-Determining X ~ Y in Internet Explorer


Download

LibriVox's New Releases

Blog Archive