我来帮你吧~~~~~~~~~~~~~~~~~``create table t(id int,name varchar(10))
insert into t select 1,'AA1'
insert into t select 2,'AB1'
insert into t select 3,'AC1'
insert into t select 4,'AA1'
insert into t select 5,'DA1'
insert into t select 6,'AA1'
insert into t select 7,'DA1'
insert into t select 8,'AA1'
insert into t select 9,'EA1'declare @var varchar(200)
SET @var='SELECT * from t where name like ''A'''+'+'+'''%'''
execute (@var)drop table t
----------------------------------------------
id name
1 AA1
2 AB1
3 AC1
4 AA1
6 AA1
8 AA1
insert into t select 1,'AA1'
insert into t select 2,'AB1'
insert into t select 3,'AC1'
insert into t select 4,'AA1'
insert into t select 5,'DA1'
insert into t select 6,'AA1'
insert into t select 7,'DA1'
insert into t select 8,'AA1'
insert into t select 9,'EA1'declare @var varchar(200)
SET @var='SELECT * from t where name like ''A'''+'+'+'''%'''
execute (@var)drop table t
----------------------------------------------
id name
1 AA1
2 AB1
3 AC1
4 AA1
6 AA1
8 AA1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货