Advantages Of Stored Procedures?

Hi,


Generally I write all my SQL in Stored Procedures instead of using adhoc queries. But I dont feel good about stored procedures when I come across situations like this.





Lets say that I have a stored procedure something like this





CREATE PROCEDURE dbo.proc_MYSP


@CaseID char(10)


AS


SELECT * FROM TABLE1WHERE CASEID = @CASEID





Suppose in future if the field CASEID is changed to char(20) then I need to change the declaration of CaseID in all my stored procedures that take CaseID as input parameter. If I write adhoc queries then I need not worry about this. Is there any effective solution for a situation like this.





Thank you.