SqlSever comments: single-line comments and multi-line comments; sqlsever multi-line comments

SqlSever comments: single-line comments and multi-line comments; sqlsever multi-line comments

Environment: SQLServer 2008 R2
Question: I am not clear about the usage of annotations in SQLServer.

Solution:

Single line comment:--
Multi-line comment:/*......*/

Example:

Single line comment:

-Selecting the column 'student. sname' in the list is invalid because the column is not included in the aggregate function or group by clause. SELECT Student. sno, sname, AVG (grade) AS avg_g FROM Student, SC www.jb51.net WHERE Student. sno = SC. sno AND cno <> '008 'group by Student. sno -- Student not added. the column name 'sno' is not clear. Having min (grade)> = 60 order by avg_g DESC;

Multi-line comment:

/* Grant all permissions ON Student and Course tables TO users U2 and U3 grant all priviliges www.jb51.net on table Student, Course TO U2, U3; GRANT the query permission ON the table SC to all users GRANT the select on table SC TO PUBLIC; GRANT the user the permission TO query the Student TABLE and modify the Student ID TO U4 GRANT UPDATE (Sno ), select on table Student TO U4; revoke update (Sno) on table Student FROM U4 FROM user U4's Student ID modification permission ;*/

: