34,590
社区成员
发帖
与我相关
我的任务
分享
if exists(select 1 from sysobjects where name='GetAll')
drop proc GetAll
go
create proc GetAll
@id varchar(20)
as
select * from name where num like @id
go
exec GetAll '%20%'
go
--法一:
create procfeduer GetAll
@id varchar(20)='%20%'
as
select * from name where num like @id
go
--默认值方式:
execute GetAll
--指定参数值方式:
execute GetAll '%120%'
--法二:
create procfeduer GetAll
@id varchar(20)='20'
as
select * from name where num like '%'+@id+'%'
go
--默认值方式:
execute GetAll
--指定参数值方式:
execute GetAll '120'
create procfeduer GetAll
@id varchar(20) --这里不能直接赋值,声明一个变量就行了
as
select * from name where num like '%'+@id+'%' --用like要加上%,这里是找出包含@id的字段
go
--执行存储过程
execute GetAll 20 --存储过程后面跟变量@id的值
create proc GetAll
@id varchar(20)
as
declare @sql nvarchar(1000)
set @sql='select * from name where num like ''%'+@id+'%'''
exec(@sql)
go
create procfeduer GetAll
@id varchar(20)
as
select * from name where num like '%'+@id+'%'
go
execute GetAll '20'
这样是不是就可以了? 20这个变量随便变?
DECLARE @id varchar(20)
SET @id='''%20%'''
PRINT('select * from name where num like '+@id)
/*select * from name where num like '%20%'
create procfeduer GetAll
@id varchar(20)='20'
as
select * from name where num like '%'+@id+'%'
go