I am working with integer variables that are larger than 2 billion. what kind of datatype I can use for my variables and for my table's field?
* Sent via Developersdex http://www.devdev.com *
The Web Developers Index
kind of datatype I can use for my variables and for my table's field?Quote:> Hi All,
> I am working with integer variables that are larger than 2 billion. what
> * Sent via Developersdex http://www.devdev.com *
> The Web Developers Index
I am trying to populate a table (using an insert into statement) from a
larger identical table. What I would like to do is use the primary key
field "ID" which is an Integer. The problem I am having is that I can't
use the Like clause on the Int field. This is my query:
Insert INTO work_table SELECT * FROM Original_Table WHERE ID Like %00
The LIKE %00 should give me every 100th record which will yield a good
cross section of the original database. The original database contains 1.7
The problem is the query errors out due to the ID field being Int with the
wild card like statement.
If anyone knows how to get this to work or has a better method for getting
a representative sample from one table to another I would love the help.
Please reply by e-mail as well as NNTP.
Thanks in advance,