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 – 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 […]
T-SQL – Useful Resources The following resources contain additional information on T-SQL. Please use them to get more in-depth knowledge on this. Useful Video Courses 45 Lectures 4.5 hours 36 Lectures 5 hours 59 Lectures 3.5 hours 22 Lectures 1.5 hours 15 Lectures 1.5 hours 40 Lectures 3 hours Khóa học lập trình tại Toidayhoc […]