create or replace procedure 存储名称
as
begin
execute immediate 'truncate table 表名';
execute immediate 'truncate table 表名';
commit;
end;
CREATE PROCEDURE [dbo].[SSS](@TableName varchar(100)/*参数是表名*/) AS BEGIN DECLARE @SQL varchar(8000) SET @SQL ='' SELECT @SQL=@SQL+'DELETE FROM '+@TableName --SELECT @SQL /*查看@sql当前值*/ EXEC (@SQL) /*执行语句*/ END