How to change Data Type in Sql

11/15/2018 12:56 hoangphan7#1
Hello epvpers!
I want to change data type in sql server like int > bigint ...

How can i do that?

Thank's
11/15/2018 15:06 JustNrik#2
ALTER TABLE table_name
ALTER COLUMN column_name datatype;

Don't do it in a SRO database because server files will complain about it.
11/15/2018 15:41 hoangphan7#3
Quote:
Originally Posted by JustNrik View Post
ALTER TABLE table_name
ALTER COLUMN column_name datatype;

Don't do it in a SRO database because server files will complain about it.
Which i want :( change job exp and skill point to bigint
11/16/2018 13:26 concucu#4
Quote:
Originally Posted by hoangphan7 View Post
Which i want :( change job exp and skill point to bigint
fuck u
11/16/2018 19:43 JustNrik#5
Quote:
Originally Posted by hoangphan7 View Post
Which i want :( change job exp and skill point to bigint
Why? There's absolutely no reason to increase them over 2.14b. I'm sure there are better approaches for whatever your purpose is.
11/16/2018 22:20 $WeGs#6
Quote:
Originally Posted by hoangphan7 View Post
Which i want :( change job exp and skill point to bigint
Gameserver won't like that, these types are hard coded
12/10/2018 00:09 IM HictoR#7
job exp bigint will stop the gameserver u can use srzor game server and edit ini files in jobexp