62,054
社区成员
发帖
与我相关
我的任务
分享
alter procedure SearchBook
@Name VarChar(100),
@Author VarChar(30),
@Translator VarChar(30),
@Publisher VarChar(100)
as
select * from Book where Name like '%'+@Name+'%' and Author like '%'+@Author+'%'
and Translator like '%'+@Translator+'%' and Publisher like '%'+@Publisher+'%'
GO
alter procedure SearchBook
@Name VarChar(100),
@Author VarChar(30),
@Translator VarChar(30),
@Publisher VarChar(100)
as
declare @sql varchar(500)
set @sql = 'select * from Book where Name like ''%'+@Name+'%'' or Author like ''%'+
@Author+'%'' or Translator like ''%'+@Translator+'%'' or Publisher like ''%'+@Publisher+'%'''
exec(@sql)
GO
declare @sql nvarchar(4000)
set @sql = 'select * from Book where Name like '+'''%'+rtrim(@Name)+'%'''
EXEC (@sql)
declare @sql nvarchar(4000)
set @sql = 'select * from Book where Name like'+'''%'+rtrim(@Name)+'%'''