Decimal (numeric), money, and float (real) are all floating point data types in MSSQL.
Sort by storage range
Float (real)
Decimal (numeric)
Money
You can give priority to money on the amount of storage. If the amount is too large, use
Mssql is the Microsoft SQL Server that runs on windows and platforms.Mysql is an open-source database Server that runs on windows and unix \ linux platforms. Its Standard Edition is free of charge. You can visit www.mysql.comAsp \ php is just an
--Description:--1. This function ranges from Milli to trillion--2. There are four kinds of precision (yuan, angle, minute, cl, mm)--3. There are three kinds of rounding rules (rounding, picking, not 0)--parameter description: dbo. Moneytocapital
Application of two MSSQL paging stored procedure instances two kinds of MSSQL paging stored procedure instance application
MSSQL paging in small data Web site applications, do not need to save stored procedures, only tens of thousands, tens
Example 1. Back up and import the MSSQL databaseThis method is suitable for friends who do not frequently perform database backup and restoration operations.I. Database connection1. Right-click "SQL Server Group" and click "create SQL Server
Introduction of MSSQL stored procedure and application of example/*
First look at the MSSQL stored procedure creation
CREATE PROCEDURE Proc_stu
As
SELECT * FROM Student
Go
To create a process: an exampleThe human Resources program
Transferred from: http://www.maomao365.com/?p=4797Objective:Recently, we need to show the data about the numerical part in the report to the user in the form of thousands of semicolons.The following explains how to make1 Converting a numeric type to
Reprint: http://www.cnblogs.com/skylaugh/archive/2006/07/31/464107.htmlA data type is a property of the data that represents the type of information represented by the data. Any computer language defines its own data type. Of course, different
Data type
Type
Describe
Bit
Integral type
The bit data type is integral, and its value can only be 0, 1, or null. This data type is used to store data with only two possible values, such as Yes or no, True or FA
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.