创建存储过程模板

关注

原创最新推荐文章于 2026-09-18 16:51:44 发布 397 阅读 AI 写同款· GEO 优化 ›

PostgreSql存储过程模板（PROCEDURE ） PROCEDURE 语法 CREATE [ OR REPLACE ] PROCEDURE name ( [ [ argmode ] [ argname ] argtype [ { DEFAULT | = } default_expr ] [, ...] ] ) { LANGUAGE lang_name | TRANSFORM { FOR TYPE type_name } [, ... ] | [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] 阅读详情

create proc [dbo].[wp]
@tablename varchar(64)
as
set nocount on
set transaction isolation level read uncommitted
set xact_abort on
begin
–判断表存不存在
declare @tableid int = object_id(@tablename)
if @tableid is null
begin
select @tablename + ‘table not exists’ as error
return
end
–生成模板
declare @table table(code varchar(256))
insert into @table(code)
select ‘-- =============================================’ union all
select '-- Author: wll ’ union all
select '-- Create date: ’ + CONVERT (nvarchar(19),GETDATE(),120) union all
select '-- Description: ’ union all
select ‘-- =============================================’ union all
select ‘create proc p_’ union all
select ‘as’ union all
select ‘set nocount on’ union all
select ‘set transaction isolation level read uncommitted’ union all
select ‘set xact_abort on’ union all
select ‘begin’ union all
select ‘end’ union all
select ‘go’
select code as temp from @table
end