Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Are semicolons required at the end of SQL statements in SQL Server 2005?

April 26, 2017semicolons sql SQL Server statements

0

Posted

Are semicolons required at the end of SQL statements in SQL Server 2005?

1 Answer

0

Posted

No it is not required • Do comments need to go in a special place in SQL Server 2005? No its not necessary • When would you use the ROWCOUNT function versus using the WHERE clause? Returns the number of rows affected by the last statement. If the number of rows is more than 2 billion, use ROWCOUNT_BIG. Transact-SQL statements can set the value in @@ROWCOUNT in the following ways: * Set @@ROWCOUNT to the number of rows affected or read. Rows may or may not be sent to the client. * Preserve @@ROWCOUNT from the previous statement execution. * Reset @@ROWCOUNT to 0 but do not return the value to the client. Statements that make a simple assignment always set the @@ROWCOUNT value to 1. • Is SQL case-sensitive? Is SQL Server 2005 case-sensitive? No both are not case-sensitive. Case sensitivity depends on the collation you choose.