Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

在一对多中，怎样用一条命令同时删除两个表(一对多)的相关记录呢

0 views
Skip to first unread message

dongzhuo

unread,
Aug 21, 2003, 11:34:29 PM8/21/03
to
当我在单独删除父表记录时提示："DELETE 语句与 COLUMN REFERENC 约束
'FK_bom_pcs_sub_bom_pcs' 冲突"。

我的删除命令为delete from bom_pcs where bom_pcs=19;
怎样用一条命令同时删除两个表(父子)的相关记录呢


CrazyFor

unread,
Aug 21, 2003, 11:53:50 PM8/21/03
to
BEGIN TRAN
delete ...
delete ...
...
COMMIT TRAN


"dongzhuo" <dong...@yahorng.com.cn> 写入邮件
news:uvSrm6Fa...@TK2MSFTNGP09.phx.gbl...

dongzhuo

unread,
Aug 22, 2003, 12:02:15 AM8/22/03
to
建 好了怎样执行呢？

"CrazyFor" <Jian...@sicsoft.com.cn> 写入消息新闻
:#Z5MICGa...@TK2MSFTNGP12.phx.gbl...

celliona

unread,
Aug 22, 2003, 3:42:13 AM8/22/03
to
可以在ISQL或SQL QUERY ANALYZER中执行
"dongzhuo" <dong...@yahorng.com.cn> 写入消息新闻
:uqeNHKG...@TK2MSFTNGP10.phx.gbl...
0 new messages