USE [db_House]
GO
/****** Object: StoredProcedure [dbo].[proc_employee_insert] Script Date: 2021/3/31 8:50:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[proc_employee_insert]
@employee_ID varchar (10)=null,
@employee_name varchar (20)=null,
@employee_sex varchar(10)=null,
@employee_birthday datetime,
@employee_phone varchar(20),
@employee_cardID varchar(20),
@employee_address varchar(50),
@gov_id varchar (16),
@employee_study varchar(16),
@employee_basepay numeric
as
select @employee_ID=Max(employee_ID) from tb_employee
if(@employee_ID is null)
set @employee_ID='emp1001'--作動見編號就知道是什么表
else
set @employee_ID='emp'+cast(cast(substring(@employee_ID,4,4) as int)+1 as varchar(20))
insert into tb_employee values(@employee_ID,@employee_name,@employee_sex,
@employee_birthday,@employee_phone,@employee_cardID,
@employee_address,@gov_id,@employee_study,@employee_basepay)
end
uj5u.com熱心網友回復：
alter是修改，如果之前已經有了這個存盤程序，那么需要用alter修改，如果沒有的話，才是createuj5u.com熱心網友回復：
存在的Proc，就用alter。不需在新建的，用Create。
當然也可以不管存不存在，先判斷洗掉Proc。再創建：
if exists(select 1 from sysobjects where name='存盤程序命名')
Drop Proc [dbo].[存盤程序命名]
Go
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/270372.html
標籤：基礎類
上一篇：排程資料重復