SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE test (
    [No] [bigint] IDENTITY(1,1) PRIMARY key,
    [Title] [nvarchar](100) NOT NULL
);
INSERT INTO test (Title)
SELECT N'개인경비 청구서 작성 및 교육'
UNION ALL 
SELECT N'a';
2 rows affected

CREATE PROCEDURE [dbo].[Notice_Dels]            
    @SerchText  NVARCHAR(200)
AS
BEGIN
    DECLARE @Query NVARCHAR(MAX);
    SET @Query =  N'select
             N.No, 
             N.Title
        FROM test  N 
        WHERE N.Title LIKE N''%'' + @SerchText + ''%''   ';
    PRINT @Query;
    EXEC SP_EXECUTESQL @Query, N' @SerchText   NVARCHAR(200)', @SerchText   ;
END;
exec [Notice_Dels] N'개인경비';


No
Title


1
개인경비 청구서 작성 및 교육


select
             N.No, 
             N.Title
        FROM test  N 
        WHERE N.Title LIKE N'%' + @SerchText + '%'   