我现在有两个表
A
id accont name
1 aaa bbbb
2 ccc dddd
3 fff mmmmB
accont
aaa
fff我现在想做的就是删除A表的数据时,若B表中也存在,就也删除B表总得数据。例如我删除id=3时,删除后的结果,就是A表和B表都删除了account=fff的数据问题是删除语句delete 不能做左连接。麻烦高人给帮忙解决
A
id accont name
1 aaa bbbb
2 ccc dddd
3 fff mmmmB
accont
aaa
fff我现在想做的就是删除A表的数据时,若B表中也存在,就也删除B表总得数据。例如我删除id=3时,删除后的结果,就是A表和B表都删除了account=fff的数据问题是删除语句delete 不能做左连接。麻烦高人给帮忙解决
on A
after delete
as
delete B where acount in (select accont from deleted)
declare @i int set @i=3
delete @b where accont in(select accont from @a where id=3)
delete @a where id=3
declare @i int set @i=3
delete @b where accont in(select accont from @a where id=@i)
delete @a where id=@i
on A
after delete
as
delete B where acount in (select accont from deleted)
请给出代码.
int c = 0; //页面所选择的
删除的条数
for (int i=0;i<this.DataGrid1.Items.Count;i++)
{
chk = (CheckBox)this.DataGrid1.Items[i].FindControl("chk");
if (chk.Checked)
{
c ++;
result += member.DeleteMemberById(Convert.ToInt32(this.DataGrid1.DataKeys[i]));
//内部sql文:delete from t_members where Id = @id
现在我新增加了一个表,所以也想删除这个表里的字段,但是新增表盒原表 t_members里的条数不相同,新增表只是原表t_members的子集,不知道该怎么更改已有的sql文
}
} if(c == result)
{
this.lbMessage.Text = "删除会员成功!";
InitData();
}
delete @b where accont in(select accont from @a where id=@i)
delete @a where id=@i
return @@ROWCOUNT
if(c == result)
{
this.lbMessage.Text = "删除会员成功!";
InitData();
}
这段代码我就怎么也进不去
还是写两条语句.