What is Transact-SQL in Sql Server

What is Transact-SQL in Sql Server

This is one of the best SQL SERVER interview Question. In next chapter we will learn more complete Transact-SQL Features

·        Transact-SQL is Microsoft’s proprietary version of ANSI SQL which is used in all Microsoft SQL Server relational database versions.

·        T-SQL is critical to SQL Server because each SQL Server database action actually sends the database a series of T-SQL statements.

·        It is a structured programming language that contains the commands that are used to administer instances of SQL Server, create and manage all objects in an instance of SQL Server, and to insert, retrieve, modify, and delete all data in SQL Server tables.

·        SQL Server 2012 has several new T-SQL enhancements and it helps the developers to write T-SQL query faster with very less code and higher performance.

If you have any queries or suggestions, please feel free to ask in comments section.
Share this post :

Post a Comment

Please give your valuable feedback on this post. You can submit any ASP.NET article here. We will post that article in this website by your name.

Support : Ranga Rajesh Kumar
Copyright © 2012. ASP.NET Examples - All Rights Reserved
Site Designed by Ranga Rajesh Kumar