Posted by Paul on 09/20/05 22:47

Hello David,

thank you for your answer it is exactly what I need

kind regards Paul


"David Portas" <REMOVE_BEFORE_REPLYING_dportas@acm.org> schreef in bericht
news:1127237303.004486.198620@g44g2000cwa.googlegroups.com...
>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
> --
>

[Back to original message]