CREATE procedure lsj_insert(
@data smalldatetime,@fh varchar(20),@sl int,@ydlx int,@dh varchar(50),@ph varchar(50),@bz varchar(100))
as加()号
@data smalldatetime,@fh varchar(20),@sl int,@ydlx int,@dh varchar(50),@ph varchar(50),@bz varchar(100))
as加()号
@data smalldatetime,@fh varchar(20),@sl int,@ydlx int,@dh varchar(50),@ph varchar(50),@bz varchar(100))
as
declare @sql varchar(1000)
set @sql = (case @ydlx
when '101' then
'insert into [table]([1],[2],[3],[4],[5],[6],[7])values('''+convert(char(19),@data,120)+''','''+@fh+''','+rtrim(@sl)+','+rtrim(@ydlx)+','''+@dh+''','''+@ph+''','''+@bz+''')'
when '102' then
'insert into table1(1,2,3,4,5,6,7)values(@data,@fh,-@sl,@ydlx,@dh,@ph,@bz)'
when '103' then
'insert into table2(1,2,3,4,5,6,7)values(@data,@fh,@sl,@ydlx,@dh,@ph,@bz)'
when '104' then
'insert into table3(1,2,3,4,5,6,7)values(@data,@fh,-@sl,@ydlx,@dh,@ph,@bz)'
when '105' then
'insert into table4(1,2,3,4,5,6,7)values(@data,@fh,@sl,@ydlx,@dh,@ph,@bz)'
when '106'then
'insert into table5(1,2,3,4,5,6,7)values(@data,@fh,-@sl,@ydlx,@dh,@ph,@bz)'
else ''
end)
print(@sql)
--xec(@sql)
GO--按101那个改
@data smalldatetime,@fh varchar(20),@sl int,@ydlx int,@dh varchar(50),@ph varchar(50),@bz varchar(100)
as
if @ydlx = '101'
insert into table1(1,2,3,4,5,6,7)values(@data,@fh,@sl,@ydlx,@dh,@ph,@bz)
else if @ydlx = '102'
insert into table1(1,2,3,4,5,6,7)values(@data,@fh,-@sl,@ydlx,@dh,@ph,@bz)
else if @ydlx = '103'
insert into table2(1,2,3,4,5,6,7)values(@data,@fh,@sl,@ydlx,@dh,@ph,@bz)
else if @ydlx = '104'
insert into table3(1,2,3,4,5,6,7)values(@data,@fh,-@sl,@ydlx,@dh,@ph,@bz)
else if @ydlx = '105'
insert into table4(1,2,3,4,5,6,7)values(@data,@fh,@sl,@ydlx,@dh,@ph,@bz)
else if @ydlx = '106'
insert into table5(1,2,3,4,5,6,7)values(@data,@fh,-@sl,@ydlx,@dh,@ph,@bz)
GO
@data smalldatetime,@fh varchar(20),@sl int,@ydlx int,@dh varchar(50),@ph varchar(50),@bz varchar(100))
as
declare @sql varchar(1000)
set @sql = 'insert into '+case when @ydlx=101 then '[table]'
when @ydlx=102 then '[table1]'
when @ydlx=103 then '[table2]'
when @ydlx=104 then '[table3]'
when @ydlx=105 then '[table4]'
when @ydlx=106 then '[table5]' end
+'([1],[2],[3],[4],[5],[6],[7])values('''+convert(char(19),@data,120)+''','''+@fh+''','+
case when @ydlx in (101,103,105) then rtrim(@sl)
else rtrim(-@sl) end
+','+rtrim(@ydlx)+','''+@dh+''','''+@ph+''','''+@bz+''')'
print(@sql)
--xec(@sql)
GO
如何给你分数啊!!
我知道的,呵呵,谢谢啊,你哪个我试过了,可以成功的!!
你有联系方式么?最好是MSN,有问题在问你啊,不知道行不行啊,老大!!