WinBatch® Technical Support Forum

Archived Boards => COM Automation and dotNet => Topic started by: Jeff on May 25, 2017, 01:21:50 PM

Title: Delete database records
Post by: Jeff on May 25, 2017, 01:21:50 PM
Does anyone have a good example of deleting records by date from Microsoft SQL SERVER using ADO?
Title: Re: Delete database records
Post by: JTaylor on May 25, 2017, 01:49:34 PM
Plenty of ADO examples in the Tech Database.  Once you have your connection one easy way is...

SQLText = "Delete from table where ...."
myDBConn.Execute(SQLText)

Jim
Title: Re: Delete database records
Post by: stanl on May 27, 2017, 02:02:16 PM
While Jim's suggestion is straightforward and should work, you may experience difficulties. In which case

will be helpful