Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
rubs_65
Posting Yak Master
144 Posts |
Posted - 2004-10-07 : 18:04:13
|
Hi,How can i declare unsigned integer in sql server?Thanks--Harvinder |
|
Soulweaver
Starting Member
18 Posts |
Posted - 2004-10-12 : 03:23:07
|
HelloI've been searching for this for a while, as far as i could find out, SQL Server does not have unsigned ints. I got around this by declaring my variable as a bigint, and then using it as if its an unsigned in so that i could get values up to 4294967296 (unsigned INT32 ie WORD)If, unfortunately you need a BIGINT unsigned, I can't help you.-----------------------Black Holes exist where God divided by Zero----------------------- |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-12 : 04:11:12
|
Put a CONSTRAINT on an INT column to not allow numbers < 0 ??Kristen |
|
|
|
|
|