CREATE PROCEDURE usp_business_produce3add
@type1 varchar(50),
@name varchar(50),
@type3 varchar(50),
@color varchar(50),
@unit varchar(50),
@ask varchar(500),
@time31 datetime,
@time33 datetime,
@time34 datetime,
@time35 datetime,
@time36 datetime,
@time38 datetime,
@time39 datetime,
@time40 datetime,
@djbl varchar(50),
@com varchar(50),
@tel varchar(50),
@mobile varchar(50),
@munit varchar(50),
@address varchar(50),
@card1 varchar(50),
@pfile varchar(50),
@pfile1 varchar(50),
@pfile2 varchar(50),
@pfile3 varchar(50),
@person32 varchar(50),
@plman varchar(50),
@card varchar(50),
@price float,
@dpnumber float,
@onenumber float,
@twonumber float,
@total float,
@number int,
@bid int,
@uid int,
@stats intAS
declare @c varchar(50)
if @stats='2'{
select @c=obnumber from g_business_orderbill where id=@bid
}
else
{
select @c=dbnumber from g_business_developbill where id=@bid
}insert into g_business_produce3 (type1,name,type3,color,unit,ask,time31,time32,time33,time34,time35,time36,time38,time39,time40,obnumber,djbl,com,tel,mobile,munit,address,card1,pfile,pfile1,pfile2,pfile3,person31,person32,plman,card,price,dpnumber,onenumber,twonumber,total,number,bid,uid,stats)
values (@type1,@name,@type3,@color,@unit,@ask,@time31,'1900-1-1',@time33,@time34,@time35,@time36,@time38,@time39,@time40,@c,@djbl,@com,@tel,@mobile,@munit,@address,@card1,@pfile,@pfile1,@pfile2,@pfile3,'',@person32,@plman,@card,@price,@dpnumber,@onenumber,@twonumber,@total,@number,@bid,@uid,@stats)
GOif @stats='2'{
select @c=obnumber from g_business_orderbill where id=@bid
}
else
{
select @c=dbnumber from g_business_developbill where id=@bid
}说这里有语法错误?
@type1 varchar(50),
@name varchar(50),
@type3 varchar(50),
@color varchar(50),
@unit varchar(50),
@ask varchar(500),
@time31 datetime,
@time33 datetime,
@time34 datetime,
@time35 datetime,
@time36 datetime,
@time38 datetime,
@time39 datetime,
@time40 datetime,
@djbl varchar(50),
@com varchar(50),
@tel varchar(50),
@mobile varchar(50),
@munit varchar(50),
@address varchar(50),
@card1 varchar(50),
@pfile varchar(50),
@pfile1 varchar(50),
@pfile2 varchar(50),
@pfile3 varchar(50),
@person32 varchar(50),
@plman varchar(50),
@card varchar(50),
@price float,
@dpnumber float,
@onenumber float,
@twonumber float,
@total float,
@number int,
@bid int,
@uid int,
@stats intAS
declare @c varchar(50)
if @stats='2'{
select @c=obnumber from g_business_orderbill where id=@bid
}
else
{
select @c=dbnumber from g_business_developbill where id=@bid
}insert into g_business_produce3 (type1,name,type3,color,unit,ask,time31,time32,time33,time34,time35,time36,time38,time39,time40,obnumber,djbl,com,tel,mobile,munit,address,card1,pfile,pfile1,pfile2,pfile3,person31,person32,plman,card,price,dpnumber,onenumber,twonumber,total,number,bid,uid,stats)
values (@type1,@name,@type3,@color,@unit,@ask,@time31,'1900-1-1',@time33,@time34,@time35,@time36,@time38,@time39,@time40,@c,@djbl,@com,@tel,@mobile,@munit,@address,@card1,@pfile,@pfile1,@pfile2,@pfile3,'',@person32,@plman,@card,@price,@dpnumber,@onenumber,@twonumber,@total,@number,@bid,@uid,@stats)
GOif @stats='2'{
select @c=obnumber from g_business_orderbill where id=@bid
}
else
{
select @c=dbnumber from g_business_developbill where id=@bid
}说这里有语法错误?
@type1 varchar(50),
@name varchar(50),
@type3 varchar(50),
@color varchar(50),
@unit varchar(50),
@ask varchar(500),
@time31 datetime,
@time33 datetime,
@time34 datetime,
@time35 datetime,
@time36 datetime,
@time38 datetime,
@time39 datetime,
@time40 datetime,
@djbl varchar(50),
@com varchar(50),
@tel varchar(50),
@mobile varchar(50),
@munit varchar(50),
@address varchar(50),
@card1 varchar(50),
@pfile varchar(50),
@pfile1 varchar(50),
@pfile2 varchar(50),
@pfile3 varchar(50),
@person32 varchar(50),
@plman varchar(50),
@card varchar(50),
@price float,
@dpnumber float,
@onenumber float,
@twonumber float,
@total float,
@number int,
@bid int,
@uid int,
@stats int AS
begin
declare @c varchar(50)
if @stats='2'
select @c=obnumber from g_business_orderbill where id=@bid
else
being
select @c=dbnumber from g_business_developbill where id=@bid
insert into g_business_produce3 (type1,name,type3,color,unit,ask,time31,time32,time33,time34,time35,time36,time38,time39,time40,obnumber,djbl,com,tel,mobile,munit,address,card1,pfile,pfile1,pfile2,pfile3,person31,person32,plman,card,price,dpnumber,onenumber,twonumber,total,number,bid,uid,stats)
values (@type1,@name,@type3,@color,@unit,@ask,@time31,'1900-1-1',@time33,@time34,@time35,@time36,@time38,@time39,@time40,@c,@djbl,@com,@tel,@mobile,@munit,@address,@card1,@pfile,@pfile1,@pfile2,@pfile3,'',@person32,@plman,@card,@price,@dpnumber,@onenumber,@twonumber,@total,@number,@bid,@uid,@stats)
endif @stats='2'
select @c=obnumber from g_business_orderbill where id=@bid
else
select @c=dbnumber from g_business_developbill where id=@bid end
@type1 varchar(50),
@name varchar(50),
@type3 varchar(50),
@color varchar(50),
@unit varchar(50),
@ask varchar(500),
@time31 datetime,
@time33 datetime,
@time34 datetime,
@time35 datetime,
@time36 datetime,
@time38 datetime,
@time39 datetime,
@time40 datetime,
@djbl varchar(50),
@com varchar(50),
@tel varchar(50),
@mobile varchar(50),
@munit varchar(50),
@address varchar(50),
@card1 varchar(50),
@pfile varchar(50),
@pfile1 varchar(50),
@pfile2 varchar(50),
@pfile3 varchar(50),
@person32 varchar(50),
@plman varchar(50),
@card varchar(50),
@price float,
@dpnumber float,
@onenumber float,
@twonumber float,
@total float,
@number int,
@bid int,
@uid int,
@stats int AS
begin
declare @c varchar(50)
if @stats='2'
select @c=obnumber from g_business_orderbill where id=@bid
else
begin
select @c=dbnumber from g_business_developbill where id=@bid
insert into g_business_produce3 (type1,name,type3,color,unit,ask,time31,time32,time33,time34,time35,time36,time38,time39,time40,obnumber,djbl,com,tel,mobile,munit,address,card1,pfile,pfile1,pfile2,pfile3,person31,person32,plman,card,price,dpnumber,onenumber,twonumber,total,number,bid,uid,stats)
values (@type1,@name,@type3,@color,@unit,@ask,@time31,'1900-1-1',@time33,@time34,@time35,@time36,@time38,@time39,@time40,@c,@djbl,@com,@tel,@mobile,@munit,@address,@card1,@pfile,@pfile1,@pfile2,@pfile3,'',@person32,@plman,@card,@price,@dpnumber,@onenumber,@twonumber,@total,@number,@bid,@uid,@stats)
endif @stats='2'
select @c=obnumber from g_business_orderbill where id=@bid
else
select @c=dbnumber from g_business_developbill where id=@bid end