CREATE
PROCEDURE
Question_State_Num_Get
AS
declare @State nvarchar ( 100 )
declare @State1 nvarchar ( 100 )
declare @State2 nvarchar ( 100 )
set @State = ' 0 '
set @State1 = ' 1 '
set @State2 = ' 2 '
set @State = ( select count (ID) from Question where State = @State )
set @State1 = ( select count (ID) from Question where State = @State1 )
set @State2 = ( select count (ID) from Question where State = @State2 )
select @State as State, @State1 as State1, @State2 as State2
GO
AS
declare @State nvarchar ( 100 )
declare @State1 nvarchar ( 100 )
declare @State2 nvarchar ( 100 )
set @State = ' 0 '
set @State1 = ' 1 '
set @State2 = ' 2 '
set @State = ( select count (ID) from Question where State = @State )
set @State1 = ( select count (ID) from Question where State = @State1 )
set @State2 = ( select count (ID) from Question where State = @State2 )
select @State as State, @State1 as State1, @State2 as State2
GO