Skip to main content

Data Types and Advanced Data Types

  • Chapter
  • 941 Accesses

Abstract

Transact-SQL is a strongly-typed language. Columns and variables must have a valid data type, and the type is a constraint of the column. In this chapter, we will not cover all data types comprehensively. We will skip the obvious part and concentrate on specific information and on more complex and sophisticated data types that were introduced in SQL Server over time.

This is a preview of subscription content, log in via an institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   49.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Authors

Rights and permissions

Reprints and permissions

Copyright information

© 2012 Jay Natarajan, Rudi Bruchez, Scott Shaw, and Michael Coles

About this chapter

Cite this chapter

Natarajan, J., Bruchez, R., Shaw, S., Coles, M. (2012). Data Types and Advanced Data Types. In: Pro T-SQL 2012 Programmer’s Guide. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-4597-1_9

Download citation

Publish with us

Policies and ethics