T-SQL tutorial

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…

T-SQL Indexes Indices are the unique tables that the database search engine uses to speed up the data retrieval. The index is…

T-SQL INSERT STATEMENT In T-SQL, INSERT statement is used to add new rows into the table. INSERT INTO SELECT requires the data…

T-SQL JOINS T-SQL combines records from two or more tables. It is used to join the records from two or more tables…