declare @tj varchar(10) set @tj='A%' exec('SELECT max(t_cd_dj.no) INTO ss FROM t_cd_dj WHERE t_cd_dj.no like '+@tj)select * from ss
declare @tj varchar(10) set @tj='''A%''' declare @sql varchar(100) set @sql='SELECT max(t_cd_dj.no) as no INTO ss FROM t_cd_dj WHERE t_cd_dj.no like '+@tj exec(@sql) --刚才写错了
DECLARE @tj AS nvarchar(50) SET @tj=" 'A%' " SELECT max(t_cd_dj.no) INTO ss FROM t_cd_dj WHERE t_cd_dj.no like @tj GO就可以了
set @tj='A%'
exec('SELECT max(t_cd_dj.no)
INTO ss
FROM t_cd_dj
WHERE t_cd_dj.no like '+@tj)select * from ss
set @tj='''A%'''
declare @sql varchar(100)
set @sql='SELECT max(t_cd_dj.no) as no
INTO ss
FROM t_cd_dj
WHERE t_cd_dj.no like '+@tj
exec(@sql)
--刚才写错了
SET @tj=" 'A%' "
SELECT max(t_cd_dj.no)
INTO ss
FROM t_cd_dj
WHERE t_cd_dj.no like @tj
GO就可以了