Listing 3: Creating a View to bcp Data

CREATE VIEW MoneyInfoView as
SELECT Name, CONVERT(float, Salary) Salary from MoneyInfo

Data After bcp

Bill Gates	1000000000000.00
Michael Jordan	1000000000000.00
Us	5.02