SQL Server - Is SQL Server Transact-SQL Case Sensitive?

Home > SQL Server

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, 330👍, 0💬

Popular Posts:

CREATE TABLE - Creat...

How to create new tables with "CREATE TABLE" statements in SQL Server? If you want to create a new t...

About dba.FYIcenter....

What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...

Generating CREATE VI...

How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...

What Is Microsoft SQ...

What is Microsoft SQL Server in SQL Server? Microsoft SQL Server is a relational database management...

READ_ONLY/READ_WRITE...

How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...