Or you can also have inline comments as SELECT * FROM /* Customers this is comment */ SQL comment block Where MiddleName = 'E' - these are conditionsĪnd the above examples works perfectly for me in SQL Server. You can use inline comments using "-" after the query or even using "/* */" whichever works for you, I have taken example of using two dashes "-" comment after query SELECT * FROM. Multi line comments, can be used as inline comments also and syntax remains same for SQL Server, MySQL and Oracle database, it starts with "/*" and follow the comment with an asterisk and forward slash basically ends with "*/". Single line comment Syntax is same in MySQL, SQL Server and Oracle database, but in MySQL, you need to keep a space after double dashes, like this "- this is comment -" Multi Line Comments Single line comment in SQL can be done using "-Some text-", basically you need to begin your line with two dashes "–" -Single line comment.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |