declare @count int;
declare @sql varchar(400);
set @count =3;
set @sql='select * from users where name like '% s %'+ ';
exec(@sql)
我要查询name中包含s的记录set @sql='select * from users where name like + % s % + ';该如何写呢?
declare @sql varchar(400);
set @count =3;
set @sql='select * from users where name like '% s %'+ ';
exec(@sql)
我要查询name中包含s的记录set @sql='select * from users where name like + % s % + ';该如何写呢?
declare @sql varchar(400);
set @count =3;
set @sql='select * from users where name like ''%s%'''
exec(@sql)
exec(@sql)
declare @sql varchar(400);
set @count ='s';
set @sql='select * from users where name like ''%@count%'''
exec(@sql)
怎么把@count 定义为字符串,然后给他赋值,
然后查询name中包含这个字符串的记录?
declare @count varchar(10);
declare @sql varchar(400);
set @count ='s';
set @sql='select * from users where name like ''%'+@count+'%'''
exec(@sql)