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

Popular Posts:

What Are Logical/Boo...

What Are Logical/Boolean Operations in SQL Server Transact-SQL? Logical (Boolean) operations are per...

"ALTER USER" - Chang...

How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...

DATEADD() Function U...

How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...

Ending Stored Proced...

How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...

Using SELECT Stateme...

Can SELECT Statements Be Used on Views in SQL Server? Select (query) statements can be used on views...