April 19, 2004 at 10:39 pm
Dear All,
I'm trying to create a table with an unsigned integer,
what keyword should I use to create one?
in Sybase I can use the keyword UNSIGNED but what's the
equivalence in MS SQL?
Thanks for your help!
CY
April 20, 2004 at 12:31 am
AFAIK there is no UNSIGNED keyword in SQL Server. What are you trying to do?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
April 20, 2004 at 9:23 pm
No good way AFAIK to deal with unsigned data in SQL, unless your only talking a byte....32 bit however, your best bet space allowing would be to go with a bigint to avoid the 2's complimant problems, or you could try to do a computed column.
April 21, 2004 at 1:04 am
- you might use constraints to limit the numbers so only positive values are allowed.
- you could use a trigger so negative values are converted to positive values.
- but why ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply