CREATE PROCEDURE USR_PROC_ENTERPRISE_SEARCH_LIKE
@IN_FIELDNAME1 NVARCHAR(20),
@IN_value NVARCHAR(50)
去掉DBO.
注解用-----
@IN_FIELDNAME1 NVARCHAR(20),
@IN_value NVARCHAR(50)
去掉DBO.
注解用-----
调试欢乐多
@IN_FIELDNAME1 NVARCHAR(20), /*查询字段名*/
@IN_value NVARCHAR(50) /*查询的值*/
AS
SELECT
ENTNETID,
ENTNETNAME,
ENTNAME,
ENTTEL,
ENTADDRESS1,
ENTADDRESS2,
ENTBANKCODE,
ENTCONNECTPEOPLE,
ENTPOSTCODE,
ENTZIP,
ENTMARK,
ENTCOUNTRYID,
ENTCOMMNET
FROM
ENTINFO
WHERE
IN_FIELDNAME1 LIKE '%' + @IN_value + '%'
/*^^^^^^^^^^^^*/
GO 另:你的ENTINFO里是否有IN_FIELDNAME1這個欄位啊???
where in_fieldname1 like '%' + @in_value + '%'
……
FROM
ENTINFO
WHERE
@IN_FIELDNAME1 LIKE '%' + @IN_value + '%'
GO