The DELETE Operand in SQL for MS ACCESS

Author: databasedev.co.uk | Published: 11th Apr 2006 | Visited: 463 times | Add Comment
Filed in: MS Access

The DELETE Operand in SQL for MS ACCESS: DELETE is one of the simpler SQL commands, and can be used to delete rows (or records) permanently from a table. It's very useful if you're trying to purge old data from your records. If you want to archive your records, however, you're better off SELECTing records and saving them to a new table first (which you'll archive), and then DELETEing the same records. Syntax for the DELETE command.....

Read Article

Sponsored Links

• Access WSDL Access WSDL and Generate Axis Stubs to Access the Web Service Remotely Now for the really cool stuff. As we discussed earlier, we have set up the ServiceMix as a separate web service gateway in front of the actual web service deployment. Now we have to check whether we can access the WSDL from the S ...

• Simple (non-JS) GridView Delete Confirmation A simple server-side solution for displaying a confirmation message upon Deleting an item in a Grid ...

• LINQ TO SQL All Common Operations (Insert,Update,Delete,Get) in ONE BASE Class Base Class to perform all Common LINQ To SQL Operat ...

• Two New FAQ Segments for Sun Java System Access Manager Here are Q&As on identity management and the service management SDK. The topics range from configurations to the Identity Repository to realms to attribu ...

• Cascading Delete Using SQL Tom, I suspect your readers will find this interesting. I am trying to logically 'Delete Cascade' across four tables, and cannot implement R.I. because we cannot guarantee the "logical parent" table would always be inserted into before its children ...

• Delete Links from the Recent Projects List on the Start Page of Visual Studio 2003, 2005 and 2008 This application deletes links from the Recent Projects list on the Start page of Visual Studio 2003/2005/ ...

Next: Mail Merging Microsoft Access Data with a Word Document