1 ALTER
PROCEDURE p_resource_info_select_by_classification_id_and_keyword
2 @classification_id INT,
3 @keyword NVARCHAR(
20)
4 AS
5 BEGIN
6 SELECT * FROM t_resource_info
WHERE
7 (
',' + ri_classifications
+ ',')
LIKE '%,' + LTRIM(
RTRIM(
STR(
@classification_id)))
+ ',%'
8 AND (
CONVERT(
VARCHAR(
MAX), ri_author)
LIKE '%<Realname>%' + @keyword + '%</Realname>%' OR ri_title_cn
LIKE '%' + @keyword + '%')
9 END
10 GO
11
12 EXEC p_resource_info_select_by_classification_id_and_keyword
110,
'a'
转载于:https://www.cnblogs.com/sunnypron/p/4482199.html
