How to change Data Type in Sql

[hoangphan7]

Hello epvpers!
I want to change data type in sql server like int > bigint ...

How can i do that?

Thank's

[JustNrik]

ALTER TABLE table_name
ALTER COLUMN column_name datatype;

Don't do it in a SRO database because server files will complain about it.

[hoangphan7]

Originally Posted by JustNrik

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

[concucu]

Originally Posted by hoangphan7

Which i want change job exp and skill point to bigint

**** u

[JustNrik]

Originally Posted by hoangphan7

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.

[$WeGs]

Originally Posted by hoangphan7

Which i want change job exp and skill point to bigint

Gameserver won't like that, these types are hard coded

[IM HictoR]

job exp bigint will stop the gameserver u can use srzor game server and edit ini files in jobexp