USE ini3_py_account;
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET DATEFORMAT ymd;
declare @ndex nvarchar(20);
declare @user varchar(32);
declare @passwd varchar(32);
declare @bhday int;
declare @sex int;
SET @ndex= 1+ (SELECT MAX(idx)
FROM dbo.Ini3_UserLogin)
--change b----------------------------------------
SET @sex = 0
SET @user = 'nameuserlogin'
SET @passwd = 'passwdlogin'
SET @bhday = 19690916
------------------------------------------------------
exec SP_PANGYA_REGIST @ndex,@sex,@bhday,0000,@user,@passwd;
exec SP_PANGYA_ACTIVATE @user;