// in a SQL query

• velezdamian

  SSC Journeyman

  Points: 94

  More actions

  April 13, 2015 at 11:19 am

  #398317

  Hello all,

  Someone recently sent me a query that contained a lot of // characters within the query. Has anyone ever used this in any of their queries, and is familiar with why this would be used in a query?

  Thanks!

  Damian

• Lowell

  SSC Guru

  Points: 323504

  More actions

  April 13, 2015 at 11:38 am

  #1790595

  // is the default way to add a line of a comment in the C++ / C# /C#.Net language.

  most likely they just copied lots of stuff to give toy you, and the //mycomment stuff will raise errors, where you'll trim them out by commenting them with SQL comments.

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• manub22

  Hall of Fame

  Points: 3163

  More actions

  April 14, 2015 at 6:59 am

  #1790781

  Microsoft SQL Server supports 2 types of commenting:

  1. Single line: by using double hyphen "--", like:

  -- this is a single line comment

  2. Multiline: /* */, like:

  /*

  This

  is

  a

  multiline

  comment

  */

  ---

  ~manoj | LinkedIn | Facebook | YouTube
  Blog: SQLwithManoj.com