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
This is for short comments only. Use the
for more discussions.
( not to be displayed)
This is to prevent automatic submission by spammers. Please enter the result of the sum as asked
Join Our Email List
you can trust
©2000-2014 plus2net.com All rights reserved worldwide