순서 지켜서 나오게 하기
카테고리 없음 / 2012. 10. 18. 10:19
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