What is a T-SQL? - www.studyandupdates.com

Wednesday

What is a T-SQL?

Q 29. What is a T-SQL?


Ans : T-SQL is an abbreviation for Transact Structure Query Language. It is a product by Microsoft and is an extension of SQL Language which is used to interact with relational databases.


It is considered to perform best with Microsoft SQL servers. T-SQL statements are used to perform the transactions to the databases. T-SQL has huge importance since all the communications with an instance of an SQL server are done by sending Transact-SQL statements to the server. Users can also define functions using T-SQL.


Types of T-SQL functions are :


➢ Aggregate functions.


➢ Ranking functions. There are different types of ranking functions.


➢ Rowset function.


➢ Scalar functions.








No comments:

Post a Comment

Popular Posts