T-SQL tutorial

T- SQL- Date Functions In T-SQL, Date functions are used to generate the query for date and time. GETDATE (): GETDATE ()…

T-SQL-Sub queries A sub-query is used with the other SQL Server query and embedded with the WHERE clause. The subquery is used…

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…