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

Popular Posts:

"sys.tables" - Getti...

How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...

What Is SQL in MySQL...

What Is SQL in MySQL? SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Rela...

MySQL Database Tutor...

Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...

About dba.FYIcenter....

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

What Is SQL Server T...

What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...