Answers for "comment in sql server query"

sql comments

Single line comments start with –- Any text after these 2 characters to the end of the line will be
ignored.
Multiline comments start with /* and end with */. They stretch across multiple lines until the
closing characters have been found.
-- My Select query
/*
This is my select query.
It grabs all rows of data from the users table
*/

sql comment

/* Multi-Line
comment
goes here */

-- Single-Line comment goes here