t-sql

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…

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…