declare @temp varchar(50)
declare @like varchar(10)
set @like='张三'
set @temp='select * from test where xm like '''+@like+'%'''
print @temp
declare @like varchar(10)
set @like='张三'
set @temp='select * from test where xm like '''+@like+'%'''
print @temp
as
declare @temp varchar(50)
declare @like varchar(10)
set @like='张三'
set @temp='select * from test where xm like '''+@like+'%'''
print @temp
create proc Test
as
declare @temp varchar(50)
declare @like varchar(10)
set @like='张三'
set @temp='select * from test where xm like '''+@like+'%'''
exec (@temp)
declare @like varchar(10)
set @like='张三'
set @temp='select * from test where xm like '''+@like+'%'''
print @temp----在sql中,2个''表示一个'