我想这样
Create Procedure P_Del
@id int,
@t_n xxx
as
if not (select max(@id) from @t_n) is null
delete from @t_n
go
这段代码中的xxx是什么类型?
Create Procedure P_Del
@id int,
@t_n xxx
as
if not (select max(@id) from @t_n) is null
delete from @t_n
go
这段代码中的xxx是什么类型?
@id int,
@t_n varchar(10)
as
exec('select 1 from '+@t_n+' where id='+@id)
if @@rowcount=0
exec('delete from '+@t_n)
go