存储过程里的一句话:(000200010001是个变量)
select count([UGPID])from
(SELECT RTRIM([PK_GroupID]) AS [UGPID], RTRIM([GroupName]) AS [UGPName]
FROM [TB_UserGroup]
WHERE [PK_GroupID] LIKE '''+000200010001+''' +'[0-9][0-9][0-9][0-9]')M这种格式怎么写一直出现这种错误”Error converting data type varchar to numeric.“
select count([UGPID])from
(SELECT RTRIM([PK_GroupID]) AS [UGPID], RTRIM([GroupName]) AS [UGPName]
FROM [TB_UserGroup]
WHERE [PK_GroupID] LIKE '''+000200010001+''' +'[0-9][0-9][0-9][0-9]')M这种格式怎么写一直出现这种错误”Error converting data type varchar to numeric.“
修改为:
LIKE '''000200010001'''
(SELECT RTRIM([PK_GroupID]) AS [UGPID], RTRIM([GroupName]) AS [UGPName]
FROM [TB_UserGroup]
WHERE [PK_GroupID] LIKE "'+@name+'[0-9][0-9][0-9][0-9]")M
--where name like '%'+@name+'%'
--where name like "%'+@name+'%"
--如果写得不对,请参照上面所写