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