CREATE PROCEDURE spAddClientInf
(
parAddress bigint,
parClientNo bigint,
parHanguang int,
parIsYes int,
parAreaGuid int
)
AS
declare rowCount int
set select rowCount = count(*) from TClient where ClientNo=parClientNo and AreaGuid= parAreaGuid
if rowCount=0
begin
insert into TClient (PoolAddr,ClientNo,CompanyID,IsYes,AreaGuid) values (parAddress,parClientNo,parHanguang,parIsYes,parAreaGuid)
end
else
begin
delete from TClient where ClientNo=parClientNo and AreaGuid = parAreaGuid insert into TClient (PoolAddr,ClientNo,CompanyID,IsYes,AreaGuid) values (parAddress,parClientNo,parHanguang,parIsYes,parAreaGuid)
end
GO
(
parAddress bigint,
parClientNo bigint,
parHanguang int,
parIsYes int,
parAreaGuid int
)
AS
declare rowCount int
set select rowCount = count(*) from TClient where ClientNo=parClientNo and AreaGuid= parAreaGuid
if rowCount=0
begin
insert into TClient (PoolAddr,ClientNo,CompanyID,IsYes,AreaGuid) values (parAddress,parClientNo,parHanguang,parIsYes,parAreaGuid)
end
else
begin
delete from TClient where ClientNo=parClientNo and AreaGuid = parAreaGuid insert into TClient (PoolAddr,ClientNo,CompanyID,IsYes,AreaGuid) values (parAddress,parClientNo,parHanguang,parIsYes,parAreaGuid)
end
GO
select count(*) into rowCount from 变通一下这个
就这句不会哦
set select rowCount = count(*) from TClient where ClientNo=parClientNo and AreaGuid= parAreaGuid
這句啊:
Declare
rowCount int;
Begin
select count(*) into rowCount
from TClient
where ClientNo=parClientNo and AreaGuid= parAreaGuid;
Exception when others then
null;
End