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 – Joining Tables The MS SQL Server Joins clause is used to combine records from two or more tables in a database. A JOIN is a means for combining fields from two tables by using values common to each. Consider the following two tables, (a) CUSTOMERS table is as follows − ID NAME AGE […]
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 […]