| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
Reference Manual Volumes 1 - 4 (Online Only) |
![[-]](/dwicons/i_colpse.gif)
| Chapter 1 System and User-Defined Datatypes |
Chapter 1
This chapter describes the Transact-SQL datatypes. Datatypes specify the type, size, and storage format of columns, stored procedure parameters, and local variables.
| Datatype categories |
| Range and storage size |
|
| Declaring the datatype of a column, variable, or parameter |
| Declaring the datatype for a column in a table |
| Declaring the datatype for a local variable in a batch or procedure |
| Declaring the datatype for a parameter in a stored procedure |
| Determining the datatype of a literal |
|
| Datatype of mixed-mode expressions |
| Determining the datatype hierarchy |
| Determining precision and scale |
|
| Converting one datatype to another |
| Automatic conversion of fixed-length NULL columns |
| Handling overflow and truncation errors |
| Standards and compliance |
|
| Exact numeric datatypes |
| Function |
| Integer types |
| Decimal datatypes |
| Standards and compliance |
|
| Approximate numeric datatypes |
| Function |
| Understanding approximate numeric datatypes |
| Range, precision, and storage size |
| Entering approximate numeric data |
| Values that may be entered by Open Client clients |
| Standards |
|
| Money datatypes |
| Function |
| Accuracy |
| Range and storage size |
| Entering monetary values |
| Standards |
|
| Timestamp datatype |
| Function |
| Creating a timestamp column |
|
| Date and time datatypes |
| Function |
| Range and storage requirements |
| Entering datetime and smalldatetime data |
| Standards and compliance |
|
| Character datatypes |
| Function |
| Length and storage size |
| Entering character data |
| Treatment of blanks |
| Manipulating character data |
| Standards |
|
| Binary datatypes |
| Function |
| Valid binary and varbinary entries |
| Entries of more than the max column size |
| Treatment of trailing zeroes |
| Platform dependence |
| Standards |
|
| bit datatype |
| Function |
| Entering data into bit columns |
| Storage size |
| Restrictions |
| Standards |
|
| sysname datatype |
| Function |
| Using the sysname datatype |
| Standards |
|
| text and image datatypes |
| Function |
![[+]](/dwicons/i_expand.gif)
| Data structures used for storing text and image data |
| Initializing text and image columns |
| Saving space by allowing NULL |
| Getting information from sysindexes |
| Using readtext and writetext |
| Determining how much space a column uses |
| Restrictions on text and image columns |
| Selecting text and image data |
| Converting text and image datatypes |
| Pattern matching in text data |
| Duplicate rows |
| Standards |
|
| User-defined datatypes |
| Function |
| Creating frequently used datatypes in the model database |
| Creating a user-defined datatypes |
| Renaming a user-defined datatype |
| Dropping a user-defined datatype |
| Getting help on datatypes |
| Standards and compliance |
|
|