How/ Why comments in SQL? Section3

0
10 views
How-Why-comments-in-SQL

In a previous article we’ve seen how we can be able to create the data is using a sequence script as well as a Server Management Studio features. We’ve also created in set up our sample data. We’ve also seen how we can be able to leverage drag control functionality in SSME so that we can be able to expedite it.

RC called development process we’ve seen how we can be able to select the top 1000 from any table. In it means without having to write any query so that we can be able to see what’s the structure of that table. If we are not familiar with that database we’ve seen how we can be able to change data in this context in a multi data environment.

This will be rather is going to be a very short one. We’ll see why we need comments as well as how we can be able to write comments and comments are a text input which are normally ignored or that are not going to be interpreted by sequencer but comments will play a major role in providing additional information about Sikorsky that we are creating.

Especially in a big database project that involves multiple developers. Sokolski it’s usually you’ll have who the author of that script is. What’s the purpose of the story. And then if there is any additional comments. And when was this screwed you did. Who created it. And if there are going to be multiple revisions to that original script we’re going to be adding the date of the revision. Who is the person who revised it. Why was there a change from the initial version. We need to specify that we also need to specify a usage of the script itself.

How is it going to be executed is it going to be executed from some windows job or is services going to call it or an API is going to call all sorts of procedures all that has to be specified so that the next person who will pick up are called to continue to evolve that will have a warning for Mission y. The script was read in what the purpose of that script is and how it’s going to be used. There are two forms sort of comments in sequence.

One is a multi-line com which is a C style comment. This is a novel he meant I am ready if I continue Adim additional lines. All of them is going to be commented out and till I add my closing syntax which is astri’s plus slush the other form of commenting is using double dashes for a single line. This is all in common. If I can teach me to try ears you’re not going to be combing.

But if I want to comment this want I can always go ahead and comment each line. Or we have additional feature in management studio we can uncomment these single line comments at once or we can comment them like this or we can do it control key control you to uncomment all control key.

Control-C to comment multiple lines together at the same time. This is what comments looks like in the course of Azi in the next article.

https://www.microsoft.com/en-us/sql-server/sql-server-downloads

Share

LEAVE A REPLY

Please enter your comment!
Please enter your name here