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!
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad I could help and thanks for the grade !