SELECT @char_gubun = CASE @v_byPCClass
WHEN 0 THEN 'A'
WHEN 1 THEN 'B'
WHEN 2 THEN 'C'
WHEN 3 THEN 'D'
WHEN 4 THEN 'E'
WHEN 5 THEN 'F'
WHEN 6 THEN 'G'
WHEN 9 THEN 'J'
WHEN 10 THEN 'K'
WHEN 11 THEN 'L'
WHEN 12 THEN 'M'
ELSE 'Z'
END
-- ???? ????? ?? (????_?????)
SET @tab_nm = 'USER_CHARACTER'+'_'+@char_gubun
SET @regdate = SUBSTRING(CONVERT(varchar(10),@ipt_time,112),1,6)+'01'
-- ??? ???? ??
EXEC sp_com_seqno @tab_nm, @regdate, @seq_no OUTPUT
IF @seq_no < 1 -- ???? ????
BEGIN
SET @sp_rtn = @seq_no
RETURN
END
-- character_no ??
SET @m_date = SUBSTRING(CONVERT(varchar(10),@ipt_time,112),3,4)
SET @character_no = @char_gubun + @m_date + @spid + dbo.FN_GetAutoNo(@seq_no,10)
-- ????? ???? ???? ??
SET @rand_no = CAST(3*Rand()+1 as INT)
SET @wh_char_no = 'DEKARON'+CAST(@v_byPCClass as varchar(2))+'000001'
How to create Database acces accounts 08/18/2012 - Shaiya Private Server - 7 Replies Hi guys. I couldn't see anywhere saying what is the procedure for creating a database acces accounts.. Couldnt find it anywhere and would be really nice if you can help me. I'm sorry if there is already such topic but i couldnt find it.
Cheers
Cannont create DATABASE :///// HELP! 01/09/2012 - SRO Private Server - 6 Replies Help me://///
http://img405.imageshack.us/img405/2856/65134345. png
How to create a database ? 02/17/2011 - Flyff Private Server - 1 Replies Hello,
I want to know how to create a database flyff (I don't want to download it, I want to create it)
Thanks for answers :mofo:
Help to Create Database (CoEmuV2) 07/03/2009 - CO2 Private Server - 0 Replies Hello...
i need help to create database coemu v2...
when i execute bath file on Navicat it say:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 10
i get this error on any sources not only coemu....
i'm studying to be a coder and if someone can help i will be gratz.