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 – Sub-Queries A sub-query or Inner query or Nested query is a query within another SQL Server query and embedded within the WHERE clause. A sub query is used to return data that will be used in the main query as a condition to further restrict the data to be retrieved. Sub queries can […]
T-SQL – Stored Procedures The MS SQL Server Stored procedure is used to save time to write code again and again by storing the same in database and also get the required output by passing parameters. Syntax Following is the basic syntax of Stored procedure creation. Create procedure <procedure_Name> As Begin <SQL Statement> End Go […]