求一条语句

[zhxiongying]

SELECT * FROM AA WHERE A IN('33', '53', '65')

上面代码中的'33', '53', '65'不确定想使用下面的形式做，应该怎么样实现呀

DECLARE @te varchar(30)
DECLARE @Egc varchar(30)
IF @te='aabb'
	BEGIN
		SELECT @Egc="'33', '53', '65'"
	END
ELSE IF @techclass='aacc'
	BEGIN
		SELECT @Egc="'32', 'DE'"
	END

SELECT * FROM AA WHERE A IN(@Egc)

[daiyueqiang2045]

DECLARE @te varchar(30)
DECLARE @Egc varchar(30)

set @te='aabb'
IF @te='aabb'    
BEGIN        
	SELECT @Egc='''33'''+','+ '''53'''+','+ '''65'''    
END
ELSE IF @te='aacc'    
BEGIN        
	SELECT @Egc='''32'''+','+'''DE'''    
END

declare @tsql varchar(6000) 
select @tsql='SELECT * FROM AA WHERE A IN('+@Egc+')' 
print @tsql
exec(@tsql)
--已测试通过

[唐诗三百首]

DECLARE @te varchar(30)
DECLARE @Egc varchar(30)
IF @te='aabb'
    BEGIN
        SELECT @Egc="'33', '53', '65'"
    END
ELSE IF @techclass='aacc'
    BEGIN
        SELECT @Egc="'32', 'DE'"
    END


declare @tsql varchar(6000)

select @tsql='SELECT * FROM AA WHERE A IN('+replace(@Egc,'''','''''')+')'

exec(@tsql)

[zhxiongying]

下面代码提示“数据库中已存在名为 '#tmp1' 的对象。”，能不能让下面的可以运行

IF @te='aa'
begin
SELECT * INTO #tmp1 FROM AA WHERE A IN('33', '53', '65')
end
else if @te='cc'
SELECT * INTO #tmp1 FROM AA WHERE A IN('3e', '5w')
end

[唐诗三百首]

try this,

SELECT * INTO #tmp1 FROM AA where 1=2

IF @te='aa'
begin
INSERT INTO #tmp1 select * FROM AA WHERE A IN('33', '53', '65')
end
else if @te='cc'
INSERT INTO #tmp1 select * FROM AA WHERE A IN('3e', '5w')
end