帮小弟我看看这个存储过程是什么有关问题，感觉逻辑有异常
日期：2014-05-17 浏览次数：20482 次
帮我看看这个存储过程是什么问题，感觉逻辑有错误！
------解决方案--------------------
USE [szht]
GO
/****** Object: StoredProcedure [dbo].[sp_insert_admin] Script Date: 2013/4/29 10:23:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_insert_admin]
@id int,
@name varchar(120),
@pwd varchar(130),
@toptime datetime,
@lasttime datetime,
@rtn int output
as
declare
@tmpname varchar(120),
@tmppwd varchar(130),
@tmptoptime datetime,
@tmplasttime datetime
if exists(select * from [Admin] where Id=@id)
begin
select @tmpname=Name,@tmppwd=Pwd,@tmptoptime=TopTime,@tmplasttime=LastTime from [Admin] where Id=@id
if((@tmpname=@name) and (@tmppwd=@pwd) and (@tmptoptime=@toptime) and (@tmplasttime=@lasttime))
begin
set @rtn=0
end
else
begin
update [Admin] set Name=@name,Pwd=@pwd,LastTime=@lasttime where Id=@id
set @rtn=2
end
end
else
if exists(select * from [Admin] where Name=@name)
begin
select @tmppwd=Pwd,@tmptoptime=TopTime,@tmplasttime=LastTime from [Admin] where Name=@name
if((@tmppwd=@pwd) and (@tmptoptime=@toptime) and (@tmplasttime=@lasttime))
begin
set @rtn=0
end
else
begin
update [Admin] set Pwd=@pwd where Name=@name
set @rtn=2
end
end
else
begin
insert into [Admin] values(@name,@pwd,@toptime,@lasttime)
set @rtn=1
end
存储
SQL
------解决方案--------------------
--是不是这个意思?
ALTER PROCEDURE [dbo].[sp_insert_admin]
@id int,
@name varchar(120),
@pwd varchar(130),
@toptime datetime,
@lasttime datetime,
@rtn int output
as
if exists(select * from [Admin] where Id=@id and Name=@name and Pwd=@tmppwd and TopTime=@tmptoptime and LastTime=@tmplasttime)
set @rtn=0
else
begin
if(exists(select * from [Admin] where Id=@id))
update [Admin]
set Name=@name and Pwd=@tmppwd and TopTime=@tmptoptime and LastTime=@tmplasttime
where id=@id
set @rtn=2
else
begin
insert?into?[Admin]?values(@name,@pwd,@toptime,@lasttime)
set?@rtn=1
end
end
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
