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

Popular Posts:

Oracle Database Tuto...

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

Managing Security, L...

Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...

EXECUTE - Executing ...

How To Execute a Stored Procedure in SQL Server Transact-SQL? If you want execute a stored procedure...

SQL Server Database ...

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

Creating a View with...

Can You Create a View with Data from Multiple Tables in SQL Server? Can You Create a View with Data ...