Bigint to int problems!

Associate
Joined
25 Feb 2007
Posts
905
Location
Midlands
I probably know the answer to this already, but I thought I'd ask.

We have a database with an ID field that has to have a datatype of int. I need to import data into this field, but some of the data I'm importing overflows the datatype (i.e. it needs to be bigint).

Is there anyway I can force this data into the field without changing the datatype, whilst also keeping each ID unique?

Thanks!

Edit: Probably should say this is SQL Server 2005!
 
There's nothing in the database. I've already changed the datatype and the import was successful, but I'm told that the app which uses the database doesn't like the change. (I've got no control over the app)
 
It's a new application that we need to interface with an existing one. Basically the app developers provide a table for me to import the data to from our existing app, but the ID field is unhelpfully set to int, so the ID's in our existing system overflow!
 
Back
Top Bottom