Are semicolons required at the end of sql statements in sql server 2005?
Answer Posted / Aman Tyagi
Yes, semicolons are required at the end of most SQL statements in SQL Server 2005 (and later versions) to denote the end of a statement. Exceptions include CREATE, DROP, and ALTER statements that end with keywords rather than identifiers.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is subquery? Explain the properties of a subquery?
what is spatial nonclustered index
How can I check that whether automatic statistic update is enabled or not?
What is a scheduled job or what is a scheduled task?
Can one drop a column from a table?
What is acid mean in sql server?
What is standby servers? Explain types of standby servers.
How to convert numeric expression data types using the cast() function?
what is the difference between openrowset and openquery?
How to enter binary string literals in ms sql server?
What is the primary use of the model database?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What are the different types of subquery?
What are wait types?
How do I create a trace in sql server?