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 |
|
imadiamond2016
Starting Member
29 Posts |
 Posted - 2011-09-01 : 03:33:24
|
| I am using SQL SERVER 2008, I have a number of INT, SMALLINT fields in my various tables, And I know they all will be 0 or greater than 0 i.e. I can take them Unsigned.Is there a simple way of creating/using Unsigned data types OR will I have to Create type->Make Rule->Use the Created Type; as specified in the following article?http://www.julian-kuiters.id.au/article.php/sqlserver2005-unsigned-integerIf this is the only way to use Unsigned in SQL, is there any disadvantage/drawback of using it? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-01 : 04:35:39
|
| instead of rule we often use check constraint on column for applying rule------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
SQL Server 2008 – Unsigned Integer Data Types