마힐링 2015.02.16 13:38 Views : 2554
동적쿼리에서 가상테이블을 사용할 수 없는건가요 ?..
ㅜ.ㅜ
2015.02.16 20:02
임시 테이블말하는건가요?
DECLARE @A NVARCHAR(100)SELECT @A = 'CREATE TABLE #A (B INT) 'SELECT @A = @A + 'INSERT #A(B) SELECT 1 'SELECT @A = @A + 'SELECT * FROM #A'
EXEC (@A)
되는데요??
cmd_comment_vote_user Upvote0 Downvote0
2015.03.24 16:35
감사합니다 처리짱님 ㅜ
Keep me signed in.
임시 테이블말하는건가요?
DECLARE @A NVARCHAR(100)
SELECT @A = 'CREATE TABLE #A (B INT) '
SELECT @A = @A + 'INSERT #A(B) SELECT 1 '
SELECT @A = @A + 'SELECT * FROM #A'
EXEC (@A)
되는데요??