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

Popular Posts:

Downloading and Inst...

How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...

Unicode Character St...

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

GO - Sending a State...

How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...

RAND() - Generating ...

How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...

CONVERT() - Converti...

How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...