create procedure delTable @ID int AS delete from tablename where id=@id if @@error=0 begin print '成功' return(0) end else begin print '不成功' return(-1) end
create procedure delTable @ID int AS delete from tablename where id=@id if @@error=0 begin print '成功' return(0) end else begin print '不成功' return(-1) endgo
create proc 名 @表名 varchar(100) as exec('TRUNCATE TABLE '+@表名) go
@ID int
AS
delete from tablename where id=@id
if @@error=0
begin
print '成功'
return(0)
end else
begin
print '不成功'
return(-1)
end
@ID int
AS
delete from tablename where id=@id
if @@error=0
begin
print '成功'
return(0)
end else
begin
print '不成功'
return(-1)
endgo
@表名 varchar(100)
as
exec('TRUNCATE TABLE '+@表名)
go
lynx1111和pengdali理解了我的意思