ALTER proc [dbo].[p_nfnid]
@cfcity varchar(50),
@mdcity varchar(50),
@hangkong varchar(50),
@cangwei varchar(50),
@travstadate DateTime,
@travenddate DateTime,
@adddate DateTime,
@addop varchar(50),
@singprice Int,
@dangqian DateTime,
@RBD varchar(50),
@Judge varchar(10),
@ID int output
as
beginSet @ID =(select top 1 id from guojipiao where cfcity=@cfcity and mdcity=@mdcity and hangkong=@hangkong and cangwei=@cangwei and travenddate<@dangqian or travstadate>@dangqian and RBD=@RBD and singprice=@singprice)
update guojipiao set adddate=@adddate,addop=@addop ,travenddate=@travenddate, travstadate=@travstadate ,Judge=@Judge
where cfcity=@cfcity and mdcity=@mdcity and hangkong=@hangkong and cangwei=@cangwei
and travenddate<@dangqian or travstadate>@dangqian and RBD=@RBD and singprice=@singpriceend
这个存储过程目的就是 修改时返回主键id
这个查询语句的条件与修改的条件一样 所以id也一样
我不知道有什么错误 取到的id总是第一条数据id 好像查询条件没点用了!
@cfcity varchar(50),
@mdcity varchar(50),
@hangkong varchar(50),
@cangwei varchar(50),
@travstadate DateTime,
@travenddate DateTime,
@adddate DateTime,
@addop varchar(50),
@singprice Int,
@dangqian DateTime,
@RBD varchar(50),
@Judge varchar(10),
@ID int output
as
beginSet @ID =(select top 1 id from guojipiao where cfcity=@cfcity and mdcity=@mdcity and hangkong=@hangkong and cangwei=@cangwei and travenddate<@dangqian or travstadate>@dangqian and RBD=@RBD and singprice=@singprice)
update guojipiao set adddate=@adddate,addop=@addop ,travenddate=@travenddate, travstadate=@travstadate ,Judge=@Judge
where cfcity=@cfcity and mdcity=@mdcity and hangkong=@hangkong and cangwei=@cangwei
and travenddate<@dangqian or travstadate>@dangqian and RBD=@RBD and singprice=@singpriceend
这个存储过程目的就是 修改时返回主键id
这个查询语句的条件与修改的条件一样 所以id也一样
我不知道有什么错误 取到的id总是第一条数据id 好像查询条件没点用了!
where (..)and(..)and()..这样试下