CREATE PROCEDURE MT_content_select
(
@content varchar(8000)
)
AS
SELECT * FROM MT_bookid WHERE convert(varchar(8000),Notes) like '%' +@content+ '%'
RETURN
GO
(
@content varchar(8000)
)
AS
SELECT * FROM MT_bookid WHERE convert(varchar(8000),Notes) like '%' +@content+ '%'
RETURN
GO