命名有点不规范~!看着累了
有表3表 tb_province , tb_city ,tb_area
关联的id provinceid -〉provinceid
cityid ->cityid然后我做级联删除 我想在删除tb_province里的这个provinceid后对应后面相关联
两表的所有信息 语句如下
create proc pro_deleteprovince
@provinceid int--大类序号
as
begin tran
declare @cityid int
delete tb_province where provinceid = @provinceid
delete tb_city where provinceid = @provinceid
set @cityid = (select cityid from tb_area where cityid in(select cityid from tb_city where provinceid = @provinceid))
delete tb_area where cityid = @cityid
commit tran为什么删除只删掉tb_province,tb_city这两个表的信息tb_area表的信息删不掉 找不出原因请教各位了,谢谢
有表3表 tb_province , tb_city ,tb_area
关联的id provinceid -〉provinceid
cityid ->cityid然后我做级联删除 我想在删除tb_province里的这个provinceid后对应后面相关联
两表的所有信息 语句如下
create proc pro_deleteprovince
@provinceid int--大类序号
as
begin tran
declare @cityid int
delete tb_province where provinceid = @provinceid
delete tb_city where provinceid = @provinceid
set @cityid = (select cityid from tb_area where cityid in(select cityid from tb_city where provinceid = @provinceid))
delete tb_area where cityid = @cityid
commit tran为什么删除只删掉tb_province,tb_city这两个表的信息tb_area表的信息删不掉 找不出原因请教各位了,谢谢
解决方案 »
- Gridview CSS样式???
- asp c#设计页面指定内容打印如何实现
- asp.net 执行SQL命令的问题
- 如何在gridview中操作xml(增删改查)
- 要一次想多个表中插入数据库
- 请问我进入网站后台后为什么,点击超连接后弹出对话框让我输入用户名和密码呢? 真的没分了大家帮帮我把
- vs2005中objectDataSource的selectParameters中配置参数源问题
- AspnetPager
- DataBinder.Eval:“System.Data.DataRowView”不包含名称为 "id" 的属性
- 在asp.net中如何在后台获取kindeditor输入的内容
- asp.net双语版网站(中文和俄文) 数据库该如何设计?
- .NET中怎么使用C#正则表达式将UBB转换为HTML
关联的id provinceid -〉provinceid
cityid ->cityid (上面对的好象不整齐)
关联的id provinceid -〉provinceid
cityid ->cityid
还是不整齐干脆说下tb_province表 有provinceid和tb_city表里provinceid对应
tb_city表里cityid和tb_area表里cityid对应
delete tb_area where cityid = @cityid 这个写在
delete tb_province where provinceid = @provinceid
delete tb_city where provinceid = @provinceid前面试试
on delete cascade了~
delete tb_city where provinceid = @provinceid
set @cityid = (select cityid from tb_area where cityid in(select cityid from tb_city where provinceid = @provinceid))
这块是不是上面的已经删除了
create proc pro_deleteprovince
@provinceid int--大类序号
as
begin tran
declare @cityid int
set @cityid = (select distinct cityid from tb_area where cityid in(select cityid from tb_city where provinceid = @provinceid))
delete tb_area where cityid = @cityid
delete tb_city where provinceid = @provinceid
delete tb_province where provinceid = @provinceid
commit tran