存储过程这样写,一直出错
IF(@ID = '0000')
select @countnum=count(*)from
(SELECT RTRIM([PK_GroupID]) AS [UGPID], RTRIM([GroupName]) AS [UGPName] FROM [TB_UserGroup] WHERE [@ID] LIKE ''____'' AND [@ID] <> ''0000'')
ELSE
select @countnum=count(*)from
(SELECT RTRIM([PK_GroupID]) AS [UGPID], RTRIM([GroupName]) AS [UGPName] FROM [TB_UserGroup] WHERE [@ID] LIKE ''' + @ID + '[0-9][0-9][0-9][0-9]'')
IF(@ID = '0000')
select @countnum=count(*)from
(SELECT RTRIM([PK_GroupID]) AS [UGPID], RTRIM([GroupName]) AS [UGPName] FROM [TB_UserGroup] WHERE [@ID] LIKE ''____'' AND [@ID] <> ''0000'')
ELSE
select @countnum=count(*)from
(SELECT RTRIM([PK_GroupID]) AS [UGPID], RTRIM([GroupName]) AS [UGPName] FROM [TB_UserGroup] WHERE [@ID] LIKE ''' + @ID + '[0-9][0-9][0-9][0-9]'')
select @countnum=count(*)from
(SELECT RTRIM([PK_GroupID]) AS [UGPID], RTRIM([GroupName]) AS [UGPName] FROM [TB_UserGroup] WHERE [@ID] LIKE ''____'' AND [@ID] <> ''0000'') M
ELSE
select @countnum=count(*)from
(SELECT RTRIM([PK_GroupID]) AS [UGPID], RTRIM([GroupName]) AS [UGPName] FROM [TB_UserGroup] WHERE [@ID] LIKE ''' + @ID + '[0-9][0-9][0-9][0-9]'') M
select @countnum=count(*) from
(SELECT RTRIM([PK_GroupID]) AS [UGPID], RTRIM([GroupName]) AS [UGPName] FROM [TB_UserGroup] WHERE [@ID] LIKE ''____'' AND [@ID] <> ''0000'') t
ELSE
select @countnum=count(*) from
(SELECT RTRIM([PK_GroupID]) AS [UGPID], RTRIM([GroupName]) AS [UGPName] FROM [TB_UserGroup] WHERE [@ID] LIKE ''' + @ID + '[0-9][0-9][0-9][0-9]'') t
(SELECT RTRIM([PK_GroupID]) AS [UGPID], RTRIM([GroupName]) AS [UGPName] FROM [TB_UserGroup] WHERE [@ID] LIKE ''____'' AND [@ID] <> ''0000'') t
IF(@ID = '0000')
begin
select @countnum=count(*) from
(SELECT RTRIM([PK_GroupID]) AS [UGPID], RTRIM([GroupName]) AS [UGPName] FROM [TB_UserGroup] WHERE [@ID] LIKE '%____%' AND [@ID] <> '0000') t
end
ELSE
begin
select @countnum=count(*) from
(SELECT RTRIM([PK_GroupID]) AS [UGPID], RTRIM([GroupName]) AS [UGPName] FROM [TB_UserGroup] WHERE [@ID] LIKE '%'+ @ID + '[0-9][0-9][0-9][0-9]') t1
end
IF(@ID = '0000')
begin
select @countnum=count(*) from
(SELECT RTRIM([PK_GroupID]) AS [UGPID], RTRIM([GroupName]) AS [UGPName] FROM [TB_UserGroup] WHERE [@ID] LIKE '%____%' AND [@ID] <> '0000') t
end
ELSE
begin
select @countnum=count(*) from
(SELECT RTRIM([PK_GroupID]) AS [UGPID], RTRIM([GroupName]) AS [UGPName] FROM [TB_UserGroup] WHERE [@ID] LIKE '%'+ @ID + '[0-9][0-9][0-9][0-9]') t1
end