|
|
|
|
|
|
|
|
|
Using Set Rowcount
SET ROWCOUNT is the old but still working method of limiting the number of rows affected by a TSQL statement. TOP N is cleaner, but you'll hit this in legacy code sooner or later and good to know what it does - and it's full behavior!
|
|
|
|
Duration:
|
1
mins
38
secs
|
|
Skill Level:
|
100
|
|
Rating:
|
4.23
out of 5
|
|
Publish Date:
|
January 05, 2010
|
|
|
|
About the Author
|
|
Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.
|
|
References
|
There are no downloads or recommended reading links for this video
|
|
|
Comments
|
|
Really liked SQL 2005 comments.
|
|
|
Short, sweet, informative.
|
|
|
Video missing
|
|
|
extremely clear speaking style
simple understandable explanation
|
|
|
Nice...
|
|
|
good
|
|
|
This was a good explanation of a basic topic
|
|
|
This was a good explanation of a basic topic
|
Must Be Logged In
|
|
|
|
|