Welcome to this course!

Functions for Manipulating Data in SQL Server

Ana Voicu

Data Engineer

Topics covered

• The most important data types
• Functions for these types:
  • Date and time functions
  • String functions
  • Functions for numeric operations

Categories of data types

• Exact numerics
• Approximate numerics
• Date and time
• Character strings
• Unicode character strings
• Binary strings
• Other data types

Exact numerics

• Whole numbers
  • smallint
  • tinyint
  • int
  • bigint

• Decimal numbers
  • numeric
  • decimal
  • money
  • smallmoney

Exact numerics - integers

Numbers without a decimal point

Data type	Storage
bigint	8 Bytes
int	4 Bytes
smallint	2 Bytes
tinyint	1 Byte

Exact numerics - decimals

Approximate numerics

• Float
• Real
• Store approximate numeric values

Date and time data types

Data type	Format	Accuracy
time	hh:mm:ss[.nnnnnnn]	100 nanoseconds
date	YYYY-MM-DD	1 day
smalldatetime	YYYY-MM-DD hh:mm:ss	1 minute
datetime	YYYY-MM-DD hh:mm:ss[.nnn]	0.00333 second
datetime2	YYYY-MM-DD hh:mm:ss[.nnnnnnn]	100 nanoseconds

Character and Unicode character data types

Character data types store character strings (ASCII)

• char
• varchar
• text

Unicode data types are used for storing Unicode data (non-ASCII)

• nchar
• nvarchar
• ntext

Other data types

• binary
• image
• cursor
• rowversion
• uniqueidentifier
• xml
• Spatial Geometry / Geography Types

Let's see what you know!

Functions for Manipulating Data in SQL Server