저장프로시져 (1) 썸네일형 리스트형 저장 프로시저 (Store Procedure) 예제 [스토어드프로스져 예제] CREATE proc spAccount_list @name varchar(20) , @accountidx int , @nickname varchar(12) , @result int OUT /* 0 -ok, 1 - error, 2 - exist */ as begin declare @name_db varchar(255) declare @name_db_where varchar(255) set @result = 0 set nocount on set @name_db=ASCII(left (@name,1)) set @name_db_where = @name_db%5 select accountidx from account_list where accountidx = @accountidx if @@.. 이전 1 다음