declare @m1 char(10) set @m1='asdfasdf' update kucunmingxiku_ycl_mx set gys_name='A'+gys_name
create table t(gys_name varchar(10)) declare @m1 varchar(10) set @m1='nk'insert into t select '1rtr' insert into t select '2dsr' insert into t select '33x'declare @sql varchar(1000) select @sql='update t set gys_name='''+@m1+'''+gys_name' exec(@sql)select * from tdrop table t --这个意思?
create table A ( name varchar(10), both datetime ) insert A select 'wew','1978-2-2' insert A select 'kkk','1981-3-31' insert A select 'll','1979-3-30' declare @m1 varchar(10) set @m1='333' update A set name=@m1+nameselect * from A
set @m1='asdfasdf'
update kucunmingxiku_ycl_mx set gys_name='A'+gys_name
declare @m1 varchar(10)
set @m1='nk'insert into t select '1rtr'
insert into t select '2dsr'
insert into t select '33x'declare @sql varchar(1000)
select @sql='update t set gys_name='''+@m1+'''+gys_name'
exec(@sql)select * from tdrop table t
--这个意思?
(
name varchar(10),
both datetime
)
insert A select 'wew','1978-2-2'
insert A select 'kkk','1981-3-31'
insert A select 'll','1979-3-30'
declare @m1 varchar(10)
set @m1='333'
update A set name=@m1+nameselect * from A