Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 /* Comment */

Author  Topic 

SamC
White Water Yakist

3467 Posts
Posted - 2004-03-17 : 12:26:28
/*
This is a valid comment !
*/

/*
And this one too! Go figure !
*/

/*
But this one fails!
Go
Figure!
*/

Sitka
Aged Yak Warrior

571 Posts
Posted - 2004-03-17 : 12:35:46
can't understand why this made me laugh. Thanks though.

It is a rich creamy color with a high fat content of 5-7 percent. Being so high in fat, it is usually processed into butter, cheese, or yogurt. An average cow will produce 110 kg. Milk in a lactation period of an average of 149 days
Go to Top of Page

X002548
Not Just a Number

15586 Posts
Posted - 2004-03-17 : 12:45:03
The all powerful GO

/*
But this one (now doesn't) fail
--Go
Figure
*/




Brett

8-)
Go to Top of Page

ditch
Master Smack Fu Yak Hacker

1466 Posts
Posted - 2004-03-17 : 13:37:58
quote:
Originally posted by Sitka
It is a rich creamy color with a high fat content of 5-7 percent. Being so high in fat, it is usually processed into butter, cheese, or yogurt. An average cow will produce 110 kg. Milk in a lactation period of an average of 149 days


I think Mr Mist will appreciate this.

http://www.sqlteam.com/forums/pop_profile.asp?mode=display&id=5995

Moo.



Duane.
Go to Top of Page

Sitka
Aged Yak Warrior

571 Posts
Posted - 2004-03-17 : 13:41:22
Hey ditch that sig has nothing to do with cows. Google it! with quotes.

It is a rich creamy color with a high fat content of 5-7 percent. Being so high in fat, it is usually processed into butter, cheese, or yogurt. An average cow will produce 110 kg. Milk in a lactation period of an average of 149 days
Go to Top of Page

ehorn
Master Smack Fu Yak Hacker

1632 Posts
Posted - 2004-03-17 : 14:03:16
I especially like these:
quote:
What is their personality like? Yaks are intelligent animals each with its own distinct personality. They learn to come when called and have a highly developed sense of sight and hearing. They make good watch dogs curiously investigating any activity in their vicinity.

How much do they cost? With only a little over 1000 breeding yaks in North America, they command a good price. Prices vary depending upon the age and training of the animals.
Appropriate
Go to Top of Page

Sitka
Aged Yak Warrior

571 Posts
Posted - 2004-03-17 : 14:29:34
Been thinking of giving up the tech life before they throw us out and become a Yak Farmer. Bet we could sell the Yak products to India, and North Dakotka could probably use a few more, intelligent animals each with its own distinct personality. Plus I do indeed like a good stinky cheese.

It is a rich creamy color with a high fat content of 5-7 percent. Being so high in fat, it is usually processed into butter, cheese, or yogurt. An average cow will produce 110 kg. Milk in a lactation period of an average of 149 days
Go to Top of Page

ditch
Master Smack Fu Yak Hacker

1466 Posts
Posted - 2004-03-17 : 14:33:38
quote:
Originally posted by Sitka

Hey ditch that sig has nothing to do with cows. Google it! with quotes.



Silly Me!

Thanks for pointing that out!


Duane.
Go to Top of Page

Sitka
Aged Yak Warrior

571 Posts
Posted - 2004-03-17 : 15:19:12
just keeping the thread on topic. ;-)

It is a rich creamy color with a high fat content of 5-7 percent. Being so high in fat, it is usually processed into butter, cheese, or yogurt. An average cow will produce 110 kg. Milk in a lactation period of an average of 149 days
Go to Top of Page

SamC
White Water Yakist

3467 Posts
Posted - 2004-03-17 : 15:29:01
My thread has been hijacked.

Is "GO" correct in breaking a comment or is it a bug?

Threads on Yak milk belong in the Yak Corral !
Go to Top of Page

ehorn
Master Smack Fu Yak Hacker

1632 Posts
Posted - 2004-03-17 : 15:35:30
BOL - /*...*/ (Comment)

Note Including a GO command within a comment generates an error message.
Go to Top of Page

SamC
White Water Yakist

3467 Posts
Posted - 2004-03-17 : 15:45:32
Document a bug, it becomes a feature.
Go to Top of Page

ehorn
Master Smack Fu Yak Hacker

1632 Posts
Posted - 2004-03-17 : 15:51:54
Not sure I would call it a bug:

/* ..*/ is a Transact SQL statement
GO is a utility command

From BOL: comments, overview

Multiple-line /* */ comments cannot span a batch. The complete comment must be contained within a batch. For example, in SQL Query Analyzer and the osql utility, the GO command signals the end of a batch. When the utilities read the characters GO in the first two bytes of a line, they send all the code since the last GO command to the server as one batch. If a GO occurs at the start of a line between the /* and */ delimiters, then an unmatched comment delimiter will be sent with each batch and they will trigger syntax errors.
Go to Top of Page

ditch
Master Smack Fu Yak Hacker

1466 Posts
Posted - 2004-03-17 : 16:39:48
It would just be so much easier if the editor in QA would pick this up and change the text color from green to black or what ever appropriate color (other than comments colors).


Duane.
Go to Top of Page

mr_mist
Grunnio

1870 Posts
Posted - 2004-03-18 : 06:23:14
I prefer the cow / yak conversation.

/* cow */
go
/* yak */

-------
Moo. :)
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

4184 Posts
Posted - 2004-03-18 : 09:29:54
/* Comment */

I'm curious why people still use this. :)

It's so easy to just highlight a whole blob of data and hit CTRL-C or CTRL-R.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

SamC
White Water Yakist

3467 Posts
Posted - 2004-03-18 : 09:32:43
You want to know why people use comments?

I put 'em in stored procedures so when I open the proc 6 months from now, there's documentation that I wrote it myself. Otherwise, I'd never take responsibility !

Sam
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

4184 Posts
Posted - 2004-03-18 : 10:22:04
????? Still haven't had that coffee huh? :) I didn't ask why people still use comments. I use them heavily. I asked why don't people just use --.

You can highlight a whole blob of text and just hit CTRL-C to comment it or CTRL-R to remove it.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

SamC
White Water Yakist

3467 Posts
Posted - 2004-03-18 : 14:29:47

Thanks for the tip. CTRL-SHIFT-C and R are handy.
Go to Top of Page

X002548
Not Just a Number

15586 Posts
Posted - 2004-03-18 : 14:39:38
quote:
Originally posted by derrickleggett

/* Comment */

I'm curious why people still use this. :)

It's so easy to just highlight a whole blob of data and hit CTRL-C or CTRL-R.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.


Well [CTRL]+C and [CTRL]+R don't work with REXX on OS/390...





Brett

8-)
Go to Top of Page

kelleyb
Yak Posting Veteran

61 Posts
Posted - 2004-03-18 : 23:06:46
quote:
Originally posted by derrickleggett
You can highlight a whole blob of text and just hit CTRL-C to comment it or CTRL-R to remove it.

Aaaaaaaaaaaaaaauuuuuuuuuggggggggghhhhhhhhh!!! That's NICE!!!
Thanks Derrick

-Brian
Go to Top of Page
    Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site