T-SQL tutorial

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 SELECT STATEMENT In T-SQL, the SELECT statement is used to fetch the data from the database table that returns the data…

Data types T-SQL Data type in SQL server is an attribute, which generates the data of the object. Each variable, column, and…

T-SQL Stored Procedures The Stored procedure in Transact SQL is used to save time to write the code, again and again. It…

T-SQL Create Table In T-SQL, we create a table, which has the name of the table and defines the columns and data…

T-SQL String Function In T-SQL, String function is applied on string value and returns the numeric data or the string value. Type…

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…