CREATE PROCEDURE GetUserNullCount(
out o_nBase int ,
out o_detail int)
begin
select o_nBase =((case when user_ext_Mobile is null then 1 else 0 end)+
(case when user_ext_PhoneNumber is null then 1 else 0 end)+
(case when user_ext_MsnNumber is null then 1 else 0 end)+
(case when user_ext_QQNumber is null then 1 else 0 end)+
(case when user_ext_OtherLinkType is null then 1 else 0 end)),
o_nMore =((case when user_ext_Height is null then 1 else 0 end)+
(case when user_ext_Education is null then 1 else 0 end)+
(case when user_ext_Housing is null then 1 else 0 end)+
(case when user_ext_WorkItem is null then 1 else 0 end)+
(case when user_ext_PayMonth is null then 1 else 0 end)+
(case when user_ext_userMarrige is null then 1 else 0 end)+
(case when user_ext_userChild is null then 1 else 0 end)),
from userlist where id=200
end
out o_nBase int ,
out o_detail int)
begin
select o_nBase =((case when user_ext_Mobile is null then 1 else 0 end)+
(case when user_ext_PhoneNumber is null then 1 else 0 end)+
(case when user_ext_MsnNumber is null then 1 else 0 end)+
(case when user_ext_QQNumber is null then 1 else 0 end)+
(case when user_ext_OtherLinkType is null then 1 else 0 end)),
o_nMore =((case when user_ext_Height is null then 1 else 0 end)+
(case when user_ext_Education is null then 1 else 0 end)+
(case when user_ext_Housing is null then 1 else 0 end)+
(case when user_ext_WorkItem is null then 1 else 0 end)+
(case when user_ext_PayMonth is null then 1 else 0 end)+
(case when user_ext_userMarrige is null then 1 else 0 end)+
(case when user_ext_userChild is null then 1 else 0 end)),
from userlist where id=200
end
out o_nBase int ,
out o_detail int)
begin
select ((case when user_ext_Mobile is null then 1 else 0 end)+
(case when user_ext_PhoneNumber is null then 1 else 0 end)+
(case when user_ext_MsnNumber is null then 1 else 0 end)+
(case when user_ext_QQNumber is null then 1 else 0 end)+
(case when user_ext_OtherLinkType is null then 1 else 0 end)),
o_nMore =((case when user_ext_Height is null then 1 else 0 end)+
(case when user_ext_Education is null then 1 else 0 end)+
(case when user_ext_Housing is null then 1 else 0 end)+
(case when user_ext_WorkItem is null then 1 else 0 end)+
(case when user_ext_PayMonth is null then 1 else 0 end)+
(case when user_ext_userMarrige is null then 1 else 0 end)+
(case when user_ext_userChild is null then 1 else 0 end)),
from userlist where id=200
end
CREATE PROCEDURE GetUserNullCount(
out o_nBase int ,
out o_detail int)
begin
select o_nBase =((case when user_ext_Mobile is null then 1 else 0 end)+
(case when user_ext_PhoneNumber is null then 1 else 0 end)+
(case when user_ext_MsnNumber is null then 1 else 0 end)+
(case when user_ext_QQNumber is null then 1 else 0 end)+
(case when user_ext_OtherLinkType is null then 1 else 0 end)),
o_nMore =((case when user_ext_Height is null then 1 else 0 end)+
(case when user_ext_Education is null then 1 else 0 end)+
(case when user_ext_Housing is null then 1 else 0 end)+
(case when user_ext_WorkItem is null then 1 else 0 end)+
(case when user_ext_PayMonth is null then 1 else 0 end)+
(case when user_ext_userMarrige is null then 1 else 0 end)+
(case when user_ext_userChild is null then 1 else 0 end)),
from userlist where id=200
endselect
CREATE PROCEDURE GetUserNullCount(
out o_nBase int ,
out o_detail int)
begin
select ((case when user_ext_Mobile is null then 1 else 0 end)+
(case when user_ext_PhoneNumber is null then 1 else 0 end)+
(case when user_ext_MsnNumber is null then 1 else 0 end)+
(case when user_ext_QQNumber is null then 1 else 0 end)+
(case when user_ext_OtherLinkType is null then 1 else 0 end)) into o_Base,
((case when user_ext_Height is null then 1 else 0 end)+
(case when user_ext_Education is null then 1 else 0 end)+
(case when user_ext_Housing is null then 1 else 0 end)+
(case when user_ext_WorkItem is null then 1 else 0 end)+
(case when user_ext_PayMonth is null then 1 else 0 end)+
(case when user_ext_userMarrige is null then 1 else 0 end)+
(case when user_ext_userChild is null then 1 else 0 end)) into o_nMore,
from userlist where id=200end
into o_Base,前的代码可以运行,之后的代码视为语法错误 ?