CREATE PROC sp_table_del
@id int
AS
begin
delete from table1 where id=@id
delete from table2 where id=@id
end ...
GO
@id int
AS
begin
delete from table1 where id=@id
delete from table2 where id=@id
end ...
GO
解决方案 »
- SQL Server 2005数据导入到SQL Server 2000中
- 找不到存储过程 'selectsnamefrom'是啥原因啊
- 如何在sql查询如何历遍记录
- SQL Server 2005中如何建立存储过程,好变态的新数据库啊!!!
- 求问like变量的问题?
- 急!急!急!急!一个错误!
- 這樣的SQL該怎樣寫!在線等>>>>>>>> 急...........
- 一个视图占用多少空间?
- To guo(还有许多):我在用sp_datach时,为什么出现了如下的错误:
- 帮忙写一段sql,重复数据取时间最近的怎么写?
- 未能找到 OLE DB 提供程序 'MICROSOFT.JET.OLEDB.4.0' 的注册表项是什么原因?
- 我想将两个表关联起来?请大家帮助!
@id int
AS
begin
delete from table1 where id=@id
delete from table2 where id=@id
...
end
GO
insert into TableDelete values('?')
.
.
.
CREATE PROC sp_table_del
@id varchar(10)
AS
set nocount on
declare @cmd varchar(8000)
set @cmd = ''
select @cmd = @cmd + 'delete ' + tblname + ' where id = ' + @id + char(10) from TableDelete
exec (@cmd)
set nocount off
GO