SQL Server Code,Tips and Tricks, Performance Tuning
A blog about SQL Server, Books, Movies and life in general
Google Interview Questions
|
Microsoft SQL Server Books
|
personal blog
|
Ken Henderson Interview
|
Louis Davidson Interview
|
Philately and Stamp Collecting
The Daily ChatGPT blog posts
Thursday, May 08, 2008
SQL Teaser: @@ROWCOUNT
Without running this what do you think will be printed?
SET
ROWCOUNT 0
DECLARE
@
int
SET
@
=
6
IF
@@ROWCOUNT
=
1
PRINT
'yes'
ELSE
PRINT
'no'
PRINT
@@rowcount
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment