CREATE PROCEDURE [SearchGlossary2]
@KeyWord varchar(200),
@GlossaryTypeID int
AS
select * from glossary where glossarytypeid=@glossarytypeid and (chinese like '%'+@KeyWord+'%' or english like '%'+@KeyWord+'%' )
Go
@KeyWord varchar(200),
@GlossaryTypeID int
AS
select * from glossary where glossarytypeid=@glossarytypeid and (chinese like '%'+@KeyWord+'%' or english like '%'+@KeyWord+'%' )
Go
@KeyWord varchar(200),
@GlossaryTypeID int
AS
select * from glossary where glossarytypeid=@glossarytypeid and (chinese like '%'+@KeyWord+'%' or english like '%'+@KeyWord+'%' )
Go