T-SQL – DELETE Statement The SQL Server DELETE Query is used to delete the existing records from a table. You have to use WHERE clause with DELETE query to delete selected rows, otherwise all the records would be deleted. Syntax Following is the basic syntax of DELETE query with WHERE clause − DELETE FROM table_name […]
Category Archives: t Sql
T-SQL – Functions MS SQL Server has many built-in functions to perform processing on string or numeric data. Following is the list of all useful SQL built-in functions − − The SQL Server COUNT aggregate function is used to count the number of rows in a database table. − The SQL Server MAX aggregate function […]
T-SQL – Transactions A transaction is a unit of work that is performed against a database. Transactions are units or sequences of work accomplished in a logical order, whether in a manual fashion by a user or automatically by some sort of a database program. A transaction is the propagation of one or more changes […]