SQL Server - Versions of SQL Server Transact-SQL

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

What Is SQL Server Transact-SQL (T-SQL)?
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension of the standard SQL (Structured Query Language). Transact-SQL was developed by Microsoft and Sybase. Microsoft's implementation ships in the Microsoft SQL Server product. Sybase uses the language in ... 2017-06-16, 1241👍, 0💬

What Is SQL Language
What Is SQL Language? SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Relational Database Management Systems). During the 1970s, a group at IBM's San Jose research center developed a database system "System R" based upon Codd's model. Structured English Query Language ("SEQ... 2017-06-16, 891👍, 0💬

Versions of SQL Server Transact-SQL
How do I tell what version of Transact-SQL my SQL Server is using? 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 ------------------------------ ------------------------------ ------------Mi... 2017-06-16, 885👍, 0💬

What Is a Statement in SQL Server Transact-SQL
What is a statement in SQL Server Transact-SQL? A statement in SQL Server Transact-SQL is a single smallest execution unit. Here are some examples of Transact-SQL statements: "PRINT 'Hello World!';" - An output statement that print a character string to the console. "SELECT GETDATE();" - A query sta... 2017-05-29, 765👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.