SQL Server 2000 Data Types

admin 

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

Description

bigint

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

int

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

smallint

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

tinyint

Integer data from 0 through 255

bit

Integer data with either a 1 or 0 value

decimal

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

numeric

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

money

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

smallmoney

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

float

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

real

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

datetime

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

smalldatetime

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 […]

admin 

건마 온라인 카지노 블랙잭

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

admin 

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 […]

admin 

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 […]

admin 

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 […]

admin 

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 […]

admin 

Leave A Comment