SQL Syntax question

Question

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

select +10 as ContentID

Is it maybe the Unary Plus operator? msdn.microsoft.com/en-us/library/ms174362.aspx — Dereleased
– Dereleased, Commented Nov 16, 2009 at 18:46

Larry Lustig · Accepted Answer · 2009-11-16 18:44:42Z

6

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

answered Nov 16, 2009 at 18:44

Larry Lustig

51.2k16 gold badges119 silver badges173 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Binary Worrier Over a year ago

Dude! Snap! That's uncanny, that is.

Binary Worrier · Accepted Answer · 2009-11-16 18:44:50Z

5

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)

answered Nov 16, 2009 at 18:44

Binary Worrier

51.8k20 gold badges144 silver badges187 bronze badges

2 Comments

Larry Lustig Over a year ago

Wow, maybe we're twins separated at birth? Almost exactly the same words.

Binary Worrier Over a year ago

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!

Collectives™ on Stack Overflow

SQL Syntax question

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related