vendredi 22 juillet 2016

DELETE unchecked report in SQL

I have reports under a company where if they are unchecked, they should be deleted. To do that, I wish to write it in SQL but I am unsure of how to write whether a report id is checked or unchecked in SQL.

This is my pseudocode,

 valsql2 = valsq2 & ";DELETE FROM CompanyReportListTable WHERE ReportID <> chk"

How would I delete an unchecked report in SQL or delete all noncheckpoints?




Aucun commentaire:

Enregistrer un commentaire