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.
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.