SQL PHP HTML ASP JavaScript articles and free scripts to download

ASP Ajax Date & time Array Form Server.MapPath Request Objects Response Objects MSSQL File System String ASP Mail

Delete records of a MSSQL table

To delete all records we can use simple delete command like this

Delete from members

This will remove all the records of members table of MSSQL database. We can also add some conditions to the query by adding a Where clause to delete a perticular record like this.

delete from member where userid ='admin2'

MSSQL Query Examples

SELECT query in collecting records from MSSQL table

TOP with SELECT query to collect number of records

SELECT query with AND OR NOT for MSSQL table

SELECT query with LIKE using wildcards % and _

Count: Counting total records in MSSQL table

Group By: SQL command in MSSQL table

Different Date & Time formats by using Convert in SELECT query

DROP table to delete table from database with IF EXISTS

DELETE records from table by using WHERE condition

Getting random records by using TOP and NEWID() in MSSQL table

Post Comment This is for short comments only. Use the forum for more discussions.
Name
Email	( not to be displayed)Privacy Policy
1+2=	This is to prevent automatic submission by spammers. Please enter the result of the sum as asked



Join Our Email List Email:

For Email Newsletters you can trust

MSSQL Query

SELECT AND OR NOT count Date formats Drop Table Delete Record Group By LIKE & _ Random record TOP

MSSQL Connection DateTime functions MSSQL Query