alter proc XinXiang_CRM_INF_Verification
(
@InType varchar(50),
@ISFOR varchar(50)
)
as
begin
DECLARE @str varchar(2000),@NUM int
create table #CRM_INF_Verification_Q_AgetID
(
ID int,
InType varchar(50),
NUM varchar(50),
Question varchar(50),
IsUse int,
CreateTime datetime,
CreateUser varchar(50)
)
set @str='insert into #CRM_INF_Verification_Q_AgetID(ID,InType,NUM,Question,IsUse,CreateTime,CreateUser)
select ID,InType,NUM,Question,IsUse,CreateTime,CreateUser from CRM_INF_Verification where Intype='''+@InType+''' order by newID()'
if(@NUM='')
begin
exec(@str)
end
Select @NUM = Count(ID) from #CRM_INF_Verification_Q_AgetID
print @NUM;
if @NUM>3
begin
select * from #CRM_INF_Verification_Q_AgetID
select top 3 ID,Question from #CRM_INF_Verification_Q_AgetID ;
delete #CRM_INF_Verification_Q_AgetID where id in (select top 3 ID from #CRM_INF_Verification_Q_AgetID );
select * from #CRM_INF_Verification_Q_AgetID
end
else
begin
if(@ISFOR='否')
begin
select top 3 Question from #CRM_INF_Verification_Q_AgetID;
delete #CRM_INF_Verification_Q_AgetID where id in (select top 3 ID from #CRM_INF_Verification_Q_AgetID);
select *,ID from #CRM_INF_Verification_Q_AgetID
end
else if(@ISFOR='是')
begin
drop table #CRM_INF_Verification_Q_AgetID
end
end
end
请问 楼主有什么问题？或者是想实现什么功能，得到什么结果?