SQL Server 2000 Data Types


SQL Server requires that each variable and column in a table should be defined with respect to the type of data it will store. From a bit to a huge image and binary storage types, the allocation is supposed to help the user conform to the data required, and help the engine allocate space and processing speed efficiently.

Built-in data types

SQL Server 2000 recognizes the following built in data types:

Data Types



Integer data from -2^63 through 2^63-1


Integer data from -2^31 through 2^31 – 1


Integer data from -2^15 through 2^15 – 1


Integer data from 0 through 255


Integer data with either a 1 or 0 value


Fixed precision and scale numeric data from -10^38 +1 through 10^38 -1


Fixed precision and scale numeric data from -10^38 +1 through 10^38 -1


Monetary data values from -2^63 through 2^63 – 1


Monetary data values from -214,748.3648 through +214,748.3647


Floating precision number data from -1.79E + 308 through  data hk  1.79E + 308


Floating precision number data from -3.40E + 38 through 3.40E + 38


Date and time data from January 1, 1753, through December 31, 9999, with an accuracy of 3.33 milliseconds


Date and time data from January 1, 1900, through June 6, 2079, with an accuracy of one minute


Recommended Posts

Accountable On the internet Wagering: Environment Limitations for any Secure Encounter

On the internet wagering provides a globe associated with exhilaration, amusement, and also the possibility of profits. Nevertheless, such as any kind of type of betting, this includes particular dangers. To make sure the secure as well as pleasant wagering encounter, it is essential to accept accountable wagering methods, such as environment limitations in your […]


건마 온라인 카지노 블랙잭

온라인 카지노는 매우 인기를 얻었고 그 다양성이 너무 커서 모든 카지노 중에서 올바른 것을 선택하는 것이 점점 더 어려워지고 있습니다. 새로운 카지노 플레이어를 유인하기 위해 일부 카지노는 무예금 카지노 보너스에서 독점적인 하이 롤러 보너스에 이르기까지 훌륭한 카지노 보너스 프로모션을 제공합니다. 일부 카지노는 게임, 고객 지원, 지불 방법, 언어 옵션, 무료 전화 번호, 뉴스 레터, 게임 […]


Why You Should Consider Online Gambling

During the last few years, online gambling has grown into one of the largest and most successful business in the world. As technology advances and becomes more efficient and user friendly the benefits to online gambling are becoming more evident. Consider just a few of the advantages of online gambling and see why you should […]


Modern Bodyguards

The modern Bodyguard, or Close Defense Officer, is generally completely different from the common perception the general public provides. A lot of people if inquired would describe the Bodyguard as some sort of large strong male, able to push anyone out involving the way. The sort of person that will you cannot want in order […]


The Sports Betting Champ System Review

The Sports Betting Champ System is a games wagering framework created by John Morrison, an Ivy League move on from Cornell University with a PhD in measurements. On the deals page there are a few elevated guarantees that the framework is “a definitive idiot proof games wagering framework” and that he makes more than “$70,000 […]


Sport Internships – What You Need to Make it Work

There are entry level positions in practically any work class you are hoping to find. In the realm of sports, this is of no exemption. From proficient groups to school to any game related organization, entry level positions are presented all through the country. Tracking down an entry level position and having the right outlook […]


Leave A Comment