Handling of COMMENTS in the GDR

re: Handling of COMMENTS in the GDR

aseniuk — Mon, 20 Jul 2009 21:16:46 GMT

How do we handle commenting in views, other then putting the comments inside the select statement like

create view xview

select

/*Comment placement is stupid now in 2008*/

column1

from

table

re: Handling of COMMENTS in the GDR

jst1699 — Tue, 24 Feb 2009 15:21:58 GMT

hi, having the comments after the BEGIN for objects is fine, but it doesn't work for views, as there is no BEGIN END.

thx

Jag

re: Handling of COMMENTS in the GDR

SafetyMan — Sun, 01 Feb 2009 21:15:04 GMT

---------------------------------------------------------------------------

--COMMENTED in SQL 2005 using comment buttons

--Comment 1 (Example From Doug Lubey Of Louisiana )

-- Comment 2 with 1 tab (douglubey.com)

-- Comment 3 with 2 tabs

--After BlankSpace

-- Comment 4 with 3 tabs

---------------------------------------------------------------------------

--Using button in SQL 2008 Enterprise studio

--Comment 1 (THE EMPTY LINE IS NOT COMMENTED)

-- Comment 2 with 1 tab

-- Comment 3 with 2 tabs

--After BlankSpace

-- Comment 4 with 3 tabs

---------------------------------------------------------------------------

To note: I also notice on occasion when working on code using sql server managment studio on SQL SERVER 2005 stored procs...comments appear right before the actuall first character in the line(or first space in the line)...

Where as in Studio 2005 had the comments left justified before the first tab in the line....In other words sql 2008 studio ignores the tabs when determing where to place the "--" comment characters.

Thanks,

Doug Lubey of Louisiana

SEARCH ENGINE REFERENCE:

SQL 2005 comments before tabs

SQL 2008 ignores tab characters in comments

SQL 2008 ignors blank lines in comments or when using comment button

re: Handling of COMMENTS in the GDR

SafetyMan — Sun, 01 Feb 2009 21:02:53 GMT

Another problem is this when writting comments or utilizing the comment buttons in SQL 2005.

We traditional create formatted coments:

search engine reference:

sql 2008 comment butons function differently than the sql 2005 comment buttons in sql 2005 are different