DB/MSSQL

[MSSQL] Bind Variables

냐옴 2017. 3. 24. 09:51

in SQL Server Management Studio

 DECLARE @AA INT
 SET @AA = 20
 SELECT @AA 


 DECLARE @AA VARCHAR(5)
 DECLARE @BB VARCHAR(3)

 SET @AA = '11111'
 SET @BB = '222'

 SELECT *
 FROM
 (
     SELECT '11111' AA, '111' BB UNION ALL
     SELECT '22222' AA, '222' BB UNION ALL
     SELECT '11111' AA, '222' BB
 ) Z
 WHERE AA = @AA
 AND BB = @BB
 ;


저작자표시 (새창열림)