|
Posted by Paul on 10/01/78 11:27
Hello David
Actually I want do also a rename command
this means not delete the record however change all subgroups with DVD in
e.g. VHS
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
> --
>
Navigation:
[Reply to this message]
|