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)

 

Is SQL Server Transact-SQL Case Sensitive?

What Is SQL Server Transact-SQL (T-SQL)?

General Questions on Microsoft SQL Server Transact-SQL

⇑⇑ SQL Server Transact-SQL Tutorials

2017-06-16, 2088🔥, 0💬