SQL Server - Versions of SQL Server Transact-SQL

Home > SQL Server

Versions of SQL Server Transact-SQL

Q

How do I tell what version of Transact-SQL my SQL Server is using?

✍: FYIcenter.com

A

The Transact-SQL version is the same as the SQL Server. You can determine the SQL Server version using the following Transact-SQL statement:

SELECT @@version

------------------------------------------------------------------------
Microsoft SQL Server 2014 - 12.0.2000.8 (Intel X86) 
	Feb 20 2014 19:20:46 
	Copyright (c) Microsoft Corporation
	Express Edition on Windows NT 6.1 <X86> (Build 7601: Service Pack 1)

⇒General Questions on Microsoft SQL Server Transact-SQL

⇒⇒SQL Server Transact-SQL Tutorials

2017-06-16, 579👍, 0💬

Popular Posts:

CONVERT() - Formatti...

How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...

FLOOR, CEILING, ROUN...

How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...

Is SQL Server Transa...

Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...

sys.procedures - Lis...

How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...

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 ...