con_cursor cursor for SELECT ~

DB 데이타 일관 처리 프로세서


Create PROCEDURE Pro_GetMutilCode
 @cityCode VARCHAR(3) 
AS

BEGIN
	DECLARE @muticodeArr varchar(100),@apCode varchar(3)
	SET @muticodeArr=@cityCode;

	Declare con_cursor cursor for SELECT AP_CODE FROM AIRPORTCODE WHERE AP_CITY_CODE=@cityCode
		open con_cursor --커스를 연다.
			fetch next from con_cursor into @apCode
			while (@@fetch_status <>-1)
			begin
				if (@@fetch_status = -2)
				continue
				begin
				-- 처리
				  set @muticodeArr += '-' + @apCode
				end
			fetch next from con_cursor into @apCode
			end
		close con_cursor
	Deallocate con_cursor

	SELECT @muticodeArr as MC_GROUP_CITY, @cityCode as MC_CITY
END

Create PROCEDURE Pro_GetMutilCode

@cityCode VARCHAR(3)

BEGIN

DECLARE @muticodeArr varchar(100),@apCode varchar(3)

SET @muticodeArr=@cityCode;

Declare con_cursor cursor for SELECT AP_CODE FROM AIRPORTCODE WHERE AP_CITY_CODE=@cityCode

open con_cursor --커스를 연다.

fetch next from con_cursor into @apCode

while (@@fetch_status <>-1)

begin

if (@@fetch_status = -2)

continue

begin

-- 처리

set @muticodeArr += '-' + @apCode

end

fetch next from con_cursor into @apCode

end

close con_cursor

Deallocate con_cursor

SELECT @muticodeArr as MC_GROUP_CITY, @cityCode as MC_CITY

END

STRING_SPLIT

문장을 구분으로 잘라 List 로 보여주기.

(2016 버전 부터 적용가능)


SELECT RULE_NO
     , RULE_NAME
     , RULE_CONTENTS
  FROM RULE
 CROSS APPLY STRING_SPLIT(RULE_CONTENTS, ' ')

SELECT RULE_NO

, RULE_NAME

, RULE_CONTENTS

FROM RULE

CROSS APPLY STRING_SPLIT(RULE_CONTENTS, ' ')