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 – String Functions MS SQL Server String functions can be applied on string value or will return string value or numeric data. Following is the list of String functions with examples. ASCII() Ascii code value will come as output for a character expression. Example The following query will give the Ascii code value of […]
T-SQL – Date Functions Following is the list of date functions in MS SQL Server. GETDATE() It will return the current date along with time. Syntax Syntax for the above function − GETDATE() Example The following query will return the current date along with time in MS SQL Server. Select getdate() as currentdatetime DATEPART() It […]