TechNet
Products
IT Resources
Downloads
Training
Support
Windows
Windows
Server
System
Center
Internet
Explorer
Office
Office 365
Exchange
Server
SQL Server
SharePoint
Products
Lync
See all products »
Evaluation Center
Learning Resources
Microsoft IT Camps
Microsoft Technical Communities
Microsoft Virtual Academy
Script Center
Server and Tools Blogs
Solution Accelerators
TechNet Blogs
TechNet Flash Newsletter
TechNet Gallery
TechNet Library
TechNet Magazine
TechNet Subscriptions
TechNet Video
TechNet Wiki
Windows Sysinternals
Virtual Labs
Networking
Cloud and Datacenter
Security
Virtualization
Service Packs
Security Bulletins
Microsoft Update
Windows Server 2012
System Center 2012 SP1
Microsoft SQL Server 2012 SP1
Windows 8 Enterprise
See all trials »
Microsoft Download Center
TechNet Evaluation Center
Drivers
Compatability & Converters
Windows Sysinternals
TechNet Gallery
Training Catalog
Class Locator
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
e-Learning overview
Certification overview
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
TechNet Events
Second shot for certification
Born To Learn blog
IT Camps
Exchange Server
Forefront Server
Forefront Edge Security
Forefront Server Security
Internet Explorer
Office
SharePoint
SQL Server
System Center
Windows Server
Windows XP
Windows Vista
Windows 7
Windows 8
Microsoft Premier Online
Microsoft Fix It Center
TechNet Forums
MSDN Forums
Security Bulletins & Advisories
International support solutions
Log a support ticket
Look up event IDs and error codes
Microsoft Customer Support
Microsoft Community Forums
United States (English)
Sign in
Print This Topic
Print Multiple Topics
Home
2012
2008 R2
2008
Previous Versions
Library
Forums
TechNet Library
SQL Server
SQL Server 2008 R2
Product Documentation
SQL Server 2008 R2 Books Online
Database Engine
Technical Reference
Transact-SQL Reference
Data Types (Transact-SQL)
Numeric Types
decimal and numeric (Transact-SQL)
float and real (Transact-SQL)
int, bigint, smallint, and tinyint (Transact-SQL)
money and smallmoney (Transact-SQL)
numeric (Transact-SQL)
real (Transact-SQL)
smallint (Transact-SQL)
smallmoney (Transact-SQL)
tinyint (Transact-SQL)
0 out of 3 rated this helpful
-
Rate this topic
smallmoney (Transact-SQL)
Other Versions
SQL Server 2005
For information about the
smallmoney
data type, see
money and smallmoney (Transact-SQL)
.
See Also
Reference
Data Types (Transact-SQL)
Concepts
Data Type Conversion (Database Engine)
Did you find this helpful?
Yes
No
Not accurate
Not enough depth
Need more code examples
Tell us more...
(
1500
characters remaining)
Community Additions
ADD
.png)
