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

Popular Posts:

SQL Server Transact-...

Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...

Unicode Character St...

How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...

CONTINUE to Next Loo...

How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...

What Causes Index Fr...

What Causes Index Fragmentation in SQL Server? Index fragmentation is usually caused by deleting of ...

Binary Literals in S...

What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...