|
Comments
|
|
Excellent
|
|
|
Very clear and informative
|
|
|
Thanks. I'm definitely going to get in the habit of always using parentheses when using TOP
|
|
|
very useful....in summary use the (), then it doesn't matter
|
|
|
I thing that another point to comment out is about using top. Because for what I know, the top behind the scenes does a select * and then gets the quantity of rows you want.
|
|
|
Thanks a lot for this demo....
|
|
|
Superb....Subir Sankar Das, Sr. Software Engineer
|
|
|
three minutes about parenthesis usage! huh!
|
|
|
Very Timely. I need to develop an web app to update 8,000+ items and I don't want all 8,000+ to appear in the update grid every time I run the query.
|
|
|
quick, clearn, and to the point.
|
|
|
As always, good info and examples. thanks Andy
|
|
|
Short, sweet and to the point.
|
|
|
I have use "top" in many, many queries but I did not know that the parenthesis were required when top is used in an update or delete statement. Thanks for the tip!
|
|
|
I would have thrown in a 30 second mention of set rowcount as the old school alternative to using top (@X) where @X is a variable for people not on SQL 2005.
|
|
|
Was very basic.
|
|
|
These kind of simple videos are good for eighth graders trying to learn SQL. Way too basic IMHO.
|
|
|
Good
|
|
|
I want more about to key word
|
|
|
nice
|
|
|
Liked it..
|
|
|
Bom
|
|
|
Hey Now Andy,
Top vid is great!
Thx 4 the info,
|
|
|
Good stuff.
|
|
|
Quick clear and to the point. very good.
|
|
|
This video is really good explainatory.
|
|
Todd Burrell on
12/10/2010
Great stuff, especially pointing out the requirement for the parentheses on the select query using the parameter.
|
|
Michael Miller on
12/10/2010
Parenthalicious!
|
|
|
I've used TOP a few times in Selects but I didn't know you could use it in Update nor did I know about the parentheses. Thanks!
|
|
|
clar and consic
|
|
|
I saw the video on TOP this morning and to my surprise I found a use for the parentheses with a parameterized TOP number a few hours later. Nice coincidence, and thank you.
|
|
R Michael Lacy on
12/10/2010
No copy of demo script today?
|
|
|
good
|
|
|
Excellent
|
|
|
I would not have guessed that TOP worked that way. Really good information.
|
|
|
great voice and pacing!!
|
|
Russell Tye on
12/12/2010
Great explanation!!!
|
|
|
good simple tip
|
|
|
How do you get rid of the results pane with just a click?
|
|
|
several examples weren't useful
|
|
|
The purpose of the parentheses wasn't explained.
|
|
Maurice Ivory on
7/15/2011
I will use the 'TOP' function in my next code.
|