Link to home
Start Free TrialLog in
Avatar of freezegravity
freezegravity

asked on

Saving percent with two decimal places in SQL Server

Hello:

So, here's a relatively easy one I think:

In a table designed like: tblProject (ProjectName, PercentOverBudget)

I want the PercentOverBudget field to be a percentage with two decimal places max and 4 places to the left of the decimal (so a valid field could be 1115.53).

I have two questions:

1. How should I declare the PercentOverBudget in SQL Server 2005?
2. I am going to write a stored procedure from an asp.net web application that is going to fill this table. How will I refer to the type of data in ASP.Net?

Thanks!
ASKER CERTIFIED SOLUTION
Avatar of Yveau
Yveau
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Glad I could help and thanks for the grade !