Is SQL Server Transact-SQL Case Sensitive?

Q

Is SQL Server Transact-SQL case sensitive?

✍: FYIcenter.com

A

No. Transact-SQL is not case sensitive. Like the standard SQL, you can type in your Transact-SQL statement in upper case or lower case.

However, you should use upper case for all key words in Transact-SQL statements as a best practice.

The following examples are all valid Transact-SQL statements:

SELECT @@VERSION
select @@version
Select @@Version
SelecT @@VersioN

 

General Questions on Microsoft SQL Server Transact-SQL

⇒⇒SQL Server Transact-SQL Tutorials

2017-06-16, 177👍, 0💬