0 votes
1 view
in SQL by (34.6k points)

Can anyone explain T-SQL?

1 Answer

0 votes
by (72.1k 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

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Jul 23, 2019 in SQL by Tech4ever (22.4k points)
0 votes
1 answer
asked Jul 23, 2019 in SQL by Tech4ever (22.4k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...