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?