Operators

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Stewart Campbell » Operators

37 posts, Page 1 of 4

1 2 3 4 »»»

Operators

Rate Topic

Display Mode

Topic Options

Author

Message

Stewart "Arturius" Campbell

Posted Saturday, March 26, 2011 2:19 PM

Hall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 3:48 AM
Points: 3,125, Visits: 4,311

Comments posted to this topic are about the item Operators

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Post #1084485

bitbucket-25253

Posted Saturday, March 26, 2011 2:22 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 4:00 PM
Points: 5,102, Visits: 20,205

Nice question

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read
Before posting a performance problem please read

Post #1084486

UMG Developer

Posted Saturday, March 26, 2011 10:13 PM

SSCrazy

Group: General Forum Members
Last Login: Monday, May 13, 2013 11:21 AM
Points: 2,163, Visits: 2,148

Thanks for the question!

Post #1084529

mohammed moinudheen

Posted Sunday, March 27, 2011 3:00 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:34 PM
Points: 2,170, Visits: 3,582

It is a very good question. Got it wrong though :)

Mohammed Moinudheen

Post #1084545

L' Eomot Inversé

Posted Sunday, March 27, 2011 6:25 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 3:07 PM
Points: 7,096, Visits: 7,156

Interesting question.

I managed to get it wrong by forgetting that += was introduced in 2008, not 2005.

One comment though: depending on settings of ARITHABORT and ANSI WARNINGS, it is quite possible that none of the answer options will result, because the batch is terminated before it reaches the select statement. I expect some people will say "just assume the defaults", but the defaults are quite different for batches run from an SSMS Query Window and for batches run from user applications (ANSI WARNINGS is ON by default in the former case, and OFF by default in the latter case) so perhaps questions like this ought to specify the settings.

Tom
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)

Post #1084564

kamaujimmywn

Posted Sunday, March 27, 2011 10:47 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, September 15, 2011 2:49 AM
Points: 2, Visits: 6

Smart question. I successfully got it wrong. I never knew that += has been introduced in 08 and the query format seemed quite confusing. There is however much more to dig deep for SQL developers. The answer given is relative.

Post #1084688

Koen Verbeeck

Posted Monday, March 28, 2011 12:26 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 6:51 AM
Points: 9,373, Visits: 6,470

Nice and easy, thanks.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1084720

Duncan Pryde

Posted Monday, March 28, 2011 1:30 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 9:32 AM
Points: 3,046, Visits: 1,306

Nice question, thanks. Took me a while to work out what was being asked!

Post #1084740

Chris Houghton

Posted Monday, March 28, 2011 1:54 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:12 AM
Points: 557, Visits: 1,356

Good question, thanks.

Post #1084748

paul.james 64212

Posted Monday, March 28, 2011 2:55 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, August 15, 2012 9:26 AM
Points: 22, Visits: 14

OK, can somebody suggest why this returns "Msg 102, Level 15, State 1, Line 4 Incorrect syntax near '='." on my 9.0.4207 SQL server?

declare @i tinyint
SELECT @i = 0
while @i < 255
SELECT @i+=1
SELECT @i

Msg 102, Level 15, State 1, Line 4
Incorrect syntax near '='.

Post #1084773

« Prev Topic | Next Topic »

37 posts, Page 1 of 4

1 2 3 4 »»»

Permissions