SQL语句WHERE 中LIKE后加字符型变量如何写?

[heaven1981]

tj='A%'
SELECT max(t_cd_dj.no)
INTO :ss
FROM t_cd_dj
WHERE (t_cd_dj.no like :tj);
执行后SS没有返回值

[-狙击手-]

感觉是PB的写法吧，，
tj="'A%'"
SELECT max(t_cd_dj.no)
INTO :ss
FROM t_cd_dj
WHERE (t_cd_dj.no like :tj);

[xeqtr1982]

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

[-狙击手-]

经测试语句是正常的，查你的表数据是不是有问题啊

[xeqtr1982]

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)
--刚才写错了

[laiker0719]

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

就可以了