编写存储过程时,like语句如何用CREATEPROCEDUREGetByListName@araecodevarchar(50)ASselectAREACODE,AREANAME,AREAFULLNAMEfromareawhere(AREACODElike'@areacode%'orPARENTCODElike'@areacode%')andISUSING='1‘GO

Question

编写存储过程时,like语句如何用
CREATE PROCEDURE GetByListName @araecode varchar(50)
AS
select AREA_CODE,AREA_NAME,AREA_FULLNAME from area where (AREA_CODE like '@area_code%'or PARENTCODE like '@area_code%') and IS_USING='1‘
GO

Answer 1

CREATE PROCEDURE GetByListName @araecode varchar(50)
AS
select AREA_CODE,AREA_NAME,AREA_FULLNAME from area where (AREA_CODE like '%'+@area_code+'%' or PARENTCODE like '%'+@area_code+'%') and IS_USING='1‘
GO