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