| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
Transact-SQL User's Guide |
![[-]](/dwicons/i_colpse.gif)
| Chapter 6 Using and Creating Datatypes |
Chapter 6
A datatype defines the kind of information each column in a table holds, and how that information is stored. You can use Adaptive Server system datatypes when you are defining columns, or you can create and use user-defined datatypes.
| How Transact-SQL datatypes work |
|
| Using system-supplied datatypes |
| Exact numeric types: integers |
| Exact numeric types: decimal numbers |
| Approximate numeric datatypes |
| Money datatypes |
| Date and time datatypes |
![[+]](/dwicons/i_expand.gif)
| Character datatypes |
|
| Binary datatypes |
| The bit datatype |
| The timestamp datatype |
| The sysname datatype |
| Converting between datatypes |
|
| Mixed-mode arithmetic and datatype hierarchy |
| Working with money datatypes |
| Determining precision and scale |
|
| Creating user-defined datatypes |
| Specifying length, precision, and scale |
| Specifying null type |
| Associating rules and defaults with user-defined datatypes |
| Creating a user-defined datatype with the IDENTITY property |
| Creating IDENTITY columns from other user-defined datatypes |
| Dropping a user-defined datatype |
| Getting information about datatypes |
|
|