블로그 이미지
010-9967-0955 보미아빠

카테고리

보미아빠, 석이 (500)
밥벌이 (16)
싸이클 (1)
일상 (1)
Total
Today
Yesterday

달력

« » 2024.3
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31

공지사항

최근에 올라온 글


IF OBJECT_ID ('TBLX') IS NOT NULL
DROP TABLE TBLX
GO

CREATE TABLE TBLX
(IDX INT
,C1 INT
,C2 INT)
GO

 

INSERT INTO TBLX VALUES (1,1,1), (2,2,2), (3,3,3),(4,4,4)
GO

 

SELECT *
  FROM (SELECT * FROM (VALUES (1), (3)) V (INSERTORDER)) A
 CROSS APPLY (SELECT * FROM TBLX WHERE IDX = INSERTORDER) B
 
SELECT *
  FROM (SELECT * FROM (VALUES (1), (3)) V (INSERTORDER)) A
 INNER LOOP JOIN TBLX B
    ON B.IDX = INSERTORDER

 

 

IF OBJECT_ID('DBO.USP_A') IS NULL
EXEC ('CREATE PROC USP_A AS SELECT 1 ')
GO   


 

ALTER PROC DBO.USP_A
(@A1 INT
,@A2 INT
,@A3 INT)
AS

SELECT *
  FROM (SELECT * FROM (VALUES (@A1), (@A2), (@A3)) V (INSERTORDER)) A
 INNER LOOP JOIN TBLX B
    ON B.IDX = INSERTORDER
GO

 

EXEC DBO.USP_A 1,2,3
EXEC DBO.USP_A 3,1,2

Posted by 보미아빠
, |

최근에 달린 댓글

최근에 받은 트랙백

글 보관함