34,838
社区成员




create table tbA(
worknum int,
date datetime
)
create PROC pro_insert(@worknum int,@date datetime)
as
if exists (select 1 from tbA where worknum = @worknum)
begin
update tbA set date = @date where worknum =@worknum
end
else
insert into tbA ( worknum, date )values (@worknum , @date)
GO
Execute pro_insert '1234','2010-6-21'
create table tb(
worknum int,
date datetime
)
insert into tb ( worknum, date )values (1234,'2010-04-21')
insert into tb ( worknum, date )values (1234,'2010-05-21')
select * from tb
结果如下:
----------------------------
Worknum date
1234 2010-04-21 00:00:00.000
1234 2010-05-21 00:00:00.000
if exists (select 1 from tb where worknum = 1234)
begin
update tb
set date = ' 2010-04-21'
where worknum = 1234
end
else
insert into tb ( worknum, date )values (1234,'2010-05-21')
结果如下:
--------------------------------------
Worknum date
1234 2010-04-21 00:00:00.000
1234 2010-04-21 00:00:00.000
CREATE PROCEDURE pinsert(
@worknum int,
@date datetime
)
as
if exists (select 1 from tb where worknum = @worknum )
begin
update tb
set date = @date
where worknum =@worknum
end
else
insert into tb ( worknum, date )values (@worknum , @date)
GO
if exists (select 1 from tb where worknum = 1234)
begin
update tb
set date = ' 2010-04-21'
where worknum = 1234
end
else
insert into tb ( worknum, date )values (1234 , '2010-04-21')