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.