|
Guy recommends : 
Find out which of your VMs are a waste of space and which VMs need more resources.
|
SQL 2000 Transact - CommentsSQL Transact CommentsGood comments show the purpose of your SQL transact query. They explain the actions that statement will perform. SQL supports two methods to block or 'Rem' out transact statements. 1) Block Comments /* .... */As the name suggests these comment are when you have a paragraph, or at least a sentence of text to introduce the script. The /* slash star.. star slash */ are mirror images or book marks. /* start block. Tell your readers the intention of the script. When you have finished explaining, perhaps adding the date when created. You need to end the block and get on with the rest of the script so: */ USE Northwind SELECT * from products GO
2) Inline commentsUSE Northwind SELECT * from products Where unitprice > 10 GO
2a) If you wanted to test your script without the following line -- Where unitprice > 10 Then you could add a pair of dashes to make an inline comment. USE Northwind SELECT * from products -- Where unitprice > 10 GO
2b) The other use of the -- two dashes, is to make a comment after statement. Then you could add a pair of dashes to make an inline comment. USE Northwind SELECT * from products -- note products not orders Where unitprice > 10 GO
Next stepLearn some more Verbs, create your own statements. *
|
|
||||
