SQL vs. PL/SQL vs. T-SQL SQL is a standard query language of the database. Where the PL/ SQL stands for “Procedural Language…
T-SQL tutorial
-
-
DELETE Query The DELETE Query in T-SQL is used to delete the existing records, which we want to remove from the table.…
-
T-SQL Transactions The Transaction is the unit of work performed opposite of the database. Any transaction that reads from or writes to…
-
T-SQL Distinct keyword In T-SQL, the DISTINCT keyword is used with the SELECT statement to eliminate duplicate records and give only the…
-
T-SQL Update Statement The T-SQL UPDATE statement is used to modify the existing records in the database. We use the WHERE clause…
-
T-SQL Drop-Table The DROP TABLE statement in T-SQL is used to remove the table definition and remove the data, indexes, triggers, constraints…
-
T-SQL WHERE Clause Where clause is used to generate the conditions while obtaining data from a table or including it in other…
-
T-SQL Functions MS SQL has many built-in functions for processing the numeric data or string. The list, given below contains the useful…
-
T-SQL Tutorial T-SQL (Transact SQL) tutorial is designed for both beginners and professionals. T-SQL expands the SQL to include procedural programming, local…
-
T-SQL GROUP BY In Transact SQL, GROUP BY clause is used to arrange the data into group. It is followed by WHERE…