Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (55.6k points)

Can anyone explain T-SQL?

1 Answer

0 votes
by (119k points)

T-SQL (Transact-SQL) is an extension of Structured Query Language from Sybase and Microsoft. T-SQL adds special features to SQL like transaction control, exception, and error handling, row processing, etc. T-SQL has queries for selecting columns, labeling output columns, restricting rows, and modifying a search condition. The main difference between SQL and T-SQL is that T-SQL contains procedural programming and local variable whereas SQL does not.

The most used T-SQL statement is the stored procedure that is similar views but the difference is stored procedures can select data and execute any T-SQL code within any parameters.

If you want to learn managing data, querying data, and programming databases using T-SQL, you can sign up for this SQL course by Intellipaat.

Related questions

Browse Categories

...