views:

82

answers:

2

What does the following statement mean? Is it an equivalent for TOP?

select +10 as ContentID
+6  A: 

No, it simply returns a result set with one row and one column (named ContentID), and that column contains the integer number 10.

Larry Lustig
Dude! Snap! That's uncanny, that is.
Binary Worrier
Great minds think alike, and whatnot :D
Dave Swersky
+5  A: 

No, it will simply return a record set with one record and one field. The field will be named ContentId and it will contain "10" (probably as an int)

Binary Worrier
Wow, maybe we're twins separated at birth? Almost exactly the same words.
Larry Lustig
Well my Mom - maysherestinpeace - spent a couple of years in New York, between 1948 and '53, maybe there's something she never told us . . . and we're both developers! This MUST be more than coincidence!
Binary Worrier