Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««23456

Are we in all these cities? Expand / Collapse
Author
Message
Posted Wednesday, September 22, 2010 9:14 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, April 04, 2014 6:01 PM
Points: 1,117, Visits: 1,217
Thanks for the question. I was ticked since I got it wrong, but it is too easy to just gloss over a script when reading it. A good reminder to be careful.

-Dan



Post #991275
Posted Tuesday, September 28, 2010 9:55 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Sunday, November 17, 2013 11:53 AM
Points: 623, Visits: 237
I thought ';' is a typo and ignored that.
Post #994908
Posted Friday, April 22, 2011 11:30 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Sunday, March 04, 2012 4:02 AM
Points: 660, Visits: 134
DhruvShah (9/28/2010)
I thought ';' is a typo and ignored that.


LOL....

Who uses a ';' anyway? it's not yet standard practice and if you do, you should realise that it would cause problems in the middle of a statement.

I need to buy some glasses now... I thought the trick was with the subquery referencing the main table with an alias, which is more informative. Suppose, I need to buy some glasses now...
Post #1097544
Posted Monday, April 25, 2011 10:14 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 27, 2014 8:50 AM
Points: 2,163, Visits: 2,184
terrykzncs (4/22/2011)
Who uses a ';' anyway? it's not yet standard practice and if you do, you should realise that it would cause problems in the middle of a statement.


For starters anyone that has to use Oracle. (Since it is required.)

Also, Microsoft has deprecated not using ; so in the next version or two of SQL Server you will probably be required to, so it might be a good idea to start now so you don't have to go back and add the ; to all of your code later.

From http://msdn.microsoft.com/en-us/library/ms143729.aspx:

Not ending Transact-SQL statements with a semicolon.
Post #1098180
« Prev Topic | Next Topic »

Add to briefcase «««23456

Permissions Expand / Collapse