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 «««123

Transaction rowcount Expand / Collapse
Author
Message
Posted Thursday, August 5, 2010 9:34 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, October 5, 2010 6:49 AM
Points: 611, Visits: 29
Ok, i didn't run the script of the question, but i thought the blank between end of line and "--" was mandatory.

Thanks anyway for your answer and explanation.

EuG
Post #964398
Posted Thursday, August 5, 2010 9:57 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 5:06 AM
Points: 365, Visits: 929
Oleg,

Thanks for the heads up and clear explanation, does make a lot of sense. Will probably remember that one for a long time.

Eugene,

Whilst it's not neccessary to have a space between the code and the comment, it's certainly nicer on the eye. The code highlighter on the forum makes it look wrong as it only identifies whole words.

Generally I'd have the spaces, as though I could write this:

SELECT 1 FROM[dbo].[table]

It's not as well written, from my opinion as - plus you're less likely to get into trouble...

SELECT 1 FROM [dbo].[table]

Post #964427
Posted Thursday, August 5, 2010 10:15 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, October 5, 2010 6:49 AM
Points: 611, Visits: 29
I agree Fozzie !
Post #964450
Posted Saturday, October 16, 2010 12:57 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 5:07 AM
Points: 8,745, Visits: 9,293
nice tidy question with no tricks. clear explanation.

Tom
Post #1005781
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse