À§¿Í °°Àº Å×À̺íÀÌ ÀÖ½À´Ï´Ù.
ÀÌ Å×ÀÌºí¿¡ ´ëÇØ
@TYPE INT
SET @TYPE = 1
ÀÌ °ªÀ» ¹Þ¾Æ
FLAG1ÀÇ °ªÀ» @FLAG INTÀÇ º¯¼ö¿¡ Áý¾î³Ö°í ½Í½À´Ï´Ù.
DECLARE @FLAG INT
SELECT @FLAG = FLAG1 FROM TABLE
À̶ó´Â SQL ±¸¹®À¸·Î ¸¸µé¾î¾ß Çϴµ¥ Åë ¾î·Æ³×¿ä.
Áö±Ý±îÁö´Â µ¿ÀûÄõ¸®·Î
DECLARE @SQL NVARCHAR(1000),
@PARAM NVARCHAR(100),
@FLAG INT = 0
SET @SQL = N'SELECT @FLAG = FLAG' + CONVERT(VARCHAR,@TYPE) + ' FROM TABLE'
SET @PARAM = N'@FLAG VARCHAR(12) OUTPUT'
EXEC SP_EXECUTESQL @SQL , @PARAM , @FLAG OUTPUT
ÀÌ·¸°Ô Àû¾î¿Ô¾ú´Âµ¥, ÀÌ°É Á¤ÀûÄõ¸®·Î ¹Ù²Ù°í ½Í´Ù´Â ¾µ´ë ¾ø´Â ¿À±â°¡ »ý°Ü¼ °í¹ÎÁßÀε¥ Àß ¾È ¶°¿À¸£³×¿ä.
Ȥ½Ã ¾î¶² ¹æ¹ýÀÌ ÀÖ´ÂÁö ¾Æ½Ã´ÂºÐ °è½Ã¸é Á¶¾ðÁ» ºÎŹµå¸³´Ï´Ù. | |
|
WHEN 2 THEN FLAG2
.....
END
FROM TABLE
º¯¼ö°¡ ¸¹À¸¸é ¸ð¸£°Ú´Âµ¥, ¸î°³ ¾ÈµÇ¸é ÀÌ·¸°Ô ÇÏ´Â°Ô ±ò²ûÇÒµí¿ä.
Çѹø È®ÀÎÇغ¼°Ô¿ä-
°¨»çÇÕ´Ï´Ù.