|
Posted by David Portas on 09/20/05 20:28
I would do it in Query Analyzser (from EM you can select Tools, SQL
Query Analyzer)
Something like this:
BEGIN TRAN
DELETE
FROM articles
WHERE subgroup = 'DVD'
SELECT * FROM articles
ROLLBACK TRAN
Once you've verified that it deleted what you expected then change the
ROLLBACK to COMMIT.
Make sure you have a backup.
--
David Portas
SQL Server MVP
--
Navigation:
[Reply to this message]
|