22,209
社区成员
发帖
与我相关
我的任务
分享
if
begin
end
else
begin
end
无语 刚才还在 .NET区 怎么就到Sql区了
create proc Insert_WorkTicketRecord
(
@WorkTickeId int,
@MachineId int,
@tiaojian int --价格条件判断是一还是二
)
as
if(@tiaojian==1)
begin
delete from WorkTicketRecord where WorkTickeId=@WorkTickeId--先删除
insert into WorkTicketRecord(WorkTickeId,MachineId) avlues(@WorkTickeId,@MachineId)-- 再插入
end
else
begin
insert into WorkTicketRecord(WorkTickeId,MachineId) avlues(@WorkTickeId,@MachineId)
end
create proc Insert_WorkTicketRecord
(
@WorkTickeId int,
@MachineId int,
@tiaojian int, --价格条件判断是一还是二
@exists int
)
as
if(@tiaojian==1)
begin
if(exists(select * from WorkTicketRecord where WorkTickeId=@WorkTickeId))
set @exists=1 --返回一个标识表示存在无法插入记录
else
insert into WorkTicketRecord(WorkTickeId,MachineId) avlues(@WorkTickeId,@MachineId)
end
else
begin
insert into WorkTicketRecord(WorkTickeId,MachineId) avlues(@WorkTickeId,@MachineId)
end
if @MachineId is null
insert into tb ()
else
……
while exists()
begin
...........
end
else
begin
...........
end