Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
My personal opinion is that C style comments should not be used by sql developers.
The problem with C Style comments is, that they do not nest.
C Style comments are one of the lifesavers for the support when they have to do some ad hoc corrections in stored procedures, but that only works well, when they don't have to fight with existing C comments.
I never use C-style comments in SQL code. First off, Management Studio gives a very easy way to comment out blocks of code with SQL-style commenting, and just as easy to uncomment it out.
And not to mention if another person opens a SQL script file not in SSMS, C-style comments have a tendency to be elusive and the commented out code doesn't look so commented.
Just my opinion, but I stay away from C-style commenting. No gain.
SQL style comments are easy to do in Management Studio (and Visual Studio) using keyboard shortcuts -> standard are ctrl+K+C (ctrl+K+U to uncomment). The C standard comments are not so easy to write at once for many lines.
My opinion is that SQL style comments are evil when used in traceable code (they cause trouble when reading user code in traces or system views).
/* ... */. Using Ctrl+K+C in SSMS generates SQL-style comments --....
Oct 17, 2011 at 15:21