一个存储过程终于写好了

最新推荐文章于 2024-06-17 15:00:11 发布

happyxzxin

最新推荐文章于 2024-06-17 15:00:11 发布

阅读量982

点赞数

文章标签：存储 insert go

本文链接：https://blog.csdn.net/happyxzxin/article/details/2587397

版权


CREATE  PROCEDURE PF_Addformula

@f_Num nvarchar(10),

@f_name nvarchar(80),

@f_field nvarchar(80),

@f_style nvarchar(20),

@f_yxcf nvarchar(200),

@f_fuliao nvarchar(200),

@f_morename nvarchar(100)

AS

insert into PF_formula (f_Num,f_name,f_field,f_style,f_yxcf,f_fuliao,f_morename,f_addtime)

 values(@f_Num,@f_name,@f_field,@f_style,@f_yxcf,@f_fuliao,@f_morename,convert(varchar(16),getdate(),109))

declare @t varchar(50),@f_id int,@a_name nvarchar(100),@a_id2 int,@i int

select @f_id=@@identity

--while(charindex(@f_fuliao,"|")<>0)

set @i=1

while(charindex('、',@f_fuliao)<>0)

begin

set @i=@i+1

set @t=left(@f_fuliao,charindex("、",@f_fuliao)-1)  

select @a_id2=a_id from PF_fuliao where a_name=@t 

 set   @f_fuliao  = right(@f_fuliao,len(@f_fuliao)-1-len(@t))

insert into pf_f_f(f_id,a_id) values(@f_id,@a_id2)



end

select @a_id2=a_id from PF_fuliao where a_name=@f_fuliao

insert into pf_f_f(f_id,a_id) values(@f_id,@a_id2)

GO