create trigger test on title
for delete
as
delete neirong from neirong n join deleted d on n.nr_lb=d.title_idcreate trigger test on neirong
for delete
as
delete xinxi from xinxi x join deleted x on x.xx_lb=d.nr_lb and x.xx_nr=d.nr_id
for delete
as
delete neirong from neirong n join deleted d on n.nr_lb=d.title_idcreate trigger test on neirong
for delete
as
delete xinxi from xinxi x join deleted x on x.xx_lb=d.nr_lb and x.xx_nr=d.nr_id
解决方案 »
- SQLSERVER2005连接本地数据库
- 存储过程 中将查询结果保存在表变量中,然后从对该表变量的行记录一一操作
- 能否得到数据库里所有cursor名称
- 答对后立即结贴,一简单Sql处理?
- 如何解除表格只读属性(SQL2000)
- 这样分页的效率好吗? 我看M$是这样写的.
- excel数据导入sqlserver时如何让某个源表中没有的字段在源表的基础上陆续加上1?
- references
- 绝对难题!!! 高手来看看 在线等!
- 现从数据库中读出一记录集,然后再让记录指针指到我想得到的记录上,如何实现?
- 提问
- 如何通过本地(局域网)的SQLserver和Internet上的计算机(有固定IP)的SQLserver连接??
delete xinxi from xinxi x join deleted x on x.xx_lb=d.nr_lb and x.xx_nr=d.nr_id