; in MSSQL

Question

"When I give only a semicolon (;) in a query, I am getting the message 'Commands completed successfully.' Are there any other symbols that can give the same result?"

Answer 1

Are there any other symbols that can give the same result?"

What for a strange question.

The semikolon is a command terminator; your "command" is empty.

You can use any "non-doing command" to get the same result, like a comment character

--

or

/* */

Answer 2

Hi @Raguram Manokaran

The semicolon (;) is used in SQL code as a statement terminator.

See this article for more details: SQL Statements Where Semicolon is Required.

Are there any other symbols that can give the same result?"

Maybe single word 'GO'.

GO signals the end of a batch of Transact-SQL statements to the SQL Server utilities.

See: SQL Server Utilities Statements - GO

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Hi Team,

"My above query is for SQL, and it has been resolved. However, we are now using a storage account, container, and files with some tags, and we have developed a custom API to retrieve the tag details. I would like to know if there are any scenarios where a storage account returns a success message similar to SQL."

Answer 4

You can use 2 more similar semicolons:

1. Double Dash (--): The double dash is used to begin a single-line comment in SQL. When you enter a statement that starts with a double dash, the entire line is treated as a comment, and the database engine will ignore it.

    -- This is a comment
   

Slash Asterisk (/* /): The slash asterisk symbols are used to begin and end a multi-line comment in SQL. When you enclose a statement between / and */, the entire block is considered a comment and will not be executed.

/* This is a multi-line comment */