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

This chapter describes the data types that are available with SQL Server, and it 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 218
Data type overview 218
The numeric data types 220
The string data types 222
The date/time data types 224
The large value data types 226
How to convert data 228
How data conversion works 228
How to convert data using the CAST function 230
How to convert data using the CONVERT function 232
How to use other data conversion functions 234
How to work with string data 236
A summary of the string functions 236
Examples that use string functions 238
How to solve common problems that occur with string data 240
How to work with numeric data 242
How to use the numeric functions 242
How to solve common problems that occur with string data 244
How to work with date/time data 246
A summary of the date/time functions 246
How to parse dates and times 248
How to perform operations on dates and times

250
How to perform a date search 252
How to perform a time search

254
Other functions you should know about 256
How to use the CASE function 256
How to use the COALESCE and ISNULL functions 258
How to use the GROUPING function 260
How to use the ranking functions 262
Perspective 266
t


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

Murach's SQL Server 2005

Learn more about this book

View the table of contents

Add this book to your cart



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.