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
 General SQL Server Forums
 New to SQL Server Programming
 Select query with /*

Author  Topic 

Suhi100
Starting Member

14 Posts

Posted - 2015-02-16 : 13:29:50
Hi,

I came across a view in Sql Management Studio where the select statement start like this:

SELECT /* (CONVERT...

i am familiar with select and convert but can someone tell what / and * stand for or what they do?

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-02-16 : 13:45:00
It's the beginning of commented out code. /* is the beginning, */ is the ending.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

Suhi100
Starting Member

14 Posts

Posted - 2015-02-16 : 15:31:09
Does it mean anything between /* and */ are excluded from the select statement?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-02-16 : 15:35:32
quote:
Originally posted by Suhi100

Does it mean anything between /* and */ are excluded from the select statement?




Yes. It's a comment block and ignored.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

Suhi100
Starting Member

14 Posts

Posted - 2015-02-16 : 15:38:33
Thanks Tara
Go to Top of Page
   

- Advertisement -