- Feb 22, 2014
- 26
- 0
- 27
Question1:
Could I reorganize the order of the item's ID number or would it totally screw the game up? The order as it is seems to be from oldest to newest items but the types of the items are all over the place and hard to find unless you've been using it for a while, know the ins and outs of sql, or have a second program which can easily sort the table next to it. If I was able to recreate the table with more organization it would be much easier for me to look through it.
Just throwing this idea out there to see if it can be done.
Otherwise Question2:
I'm looking to use an excel spreadsheet as my original database which i can easily sort through and edit as well as revert back to a previous version if something goes wrong. Then I'll import the spreadsheet to SQL as a new STDITEM table but I would keep the same ID for each item. Would importing the spreadsheet into the STDITEMS table work or would it break something in the server?
Could I reorganize the order of the item's ID number or would it totally screw the game up? The order as it is seems to be from oldest to newest items but the types of the items are all over the place and hard to find unless you've been using it for a while, know the ins and outs of sql, or have a second program which can easily sort the table next to it. If I was able to recreate the table with more organization it would be much easier for me to look through it.
Just throwing this idea out there to see if it can be done.
Otherwise Question2:
I'm looking to use an excel spreadsheet as my original database which i can easily sort through and edit as well as revert back to a previous version if something goes wrong. Then I'll import the spreadsheet to SQL as a new STDITEM table but I would keep the same ID for each item. Would importing the spreadsheet into the STDITEMS table work or would it break something in the server?
Last edited: