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

Popular Posts:

Entering 0.001 Secon...

Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...

Using User Defined F...

Where to find answers to frequently asked questions on Using User Defined Functions in SQL Server Tr...

Running Queries with...

How to run Queries with "sqlcmd" tool in SQL Server? "sqlcmd" is a client tool that you can use to i...

IF ... ELSE Statemen...

How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...

sys.database_princip...

How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...