Murach's SQL Server 2008 for Developers
How to work with data types and functions

This chapter describes the data types that are available with SQL Server, including the 2008 data types for handling date/time values. It also teaches you how to use scalar functions to work with data of various types.
Chapter 8 How to work with data types and functions
A review of the SQL data types 236
Data type overview 236
The numeric data types 238
The string data types 240
The date/time data types 242
The large value data types 244
How to convert data 246
How data conversion works 246
How to convert data using the CAST function 248
How to convert data using the CONVERT function 250
How to use other data conversion functions 252
How to work with string data 254
A summary of the string functions 254
How to solve common problems that occur with string data 258
How to work with numeric data 260
How to use the numeric functions 260
How to solve common problems that occur with numeric data 262
How to work with date/time data 264
A summary of the date/time functions 264
How to parse dates and times 268
How to perform operations on dates and times

270
How to perform a date search 272
How to perform a time search

274
Other functions you should know about 276
How to use the CASE function 276
How to use the COALESCE and ISNULL functions 278
How to use the GROUPING function 280
How to use the ranking functions 282
t


© Copyright 1998- Mike Murach & Associates, Inc.  All rights reserved.

Murach's SQL Server 2008

Learn more about this book

View the table of contents


More about the eBook



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.