Listing 2: Table That Includes the Money Datatype

CREATE table MoneyInfo (
Name varchar(30),
Salary money
)
go

INSERT INTO MoneyInfo VALUES ("Bill Gates", 1000000000000)
INSERT INTO MoneyInfo VALUES ("Michael Jordan", 1000000000000)
INSERT INTO MoneyInfo VALUES ("Us", 5.02)
go

Data After bcp

Bill Gates	1,000,000,000,000.00
Michael Jordan	1,000,000,000,000.00
Us		5.02