I've got a table called Orders
which contains about 20 fields.
1 of these fields is called Type
I have a stored procedure in place called sp_Orders
This stored procedure is executed to a SqlDataReader
on about 50 different ASP.NET pages for a variety of things.
I'm removing the Type
field from the database, and therefore from sp_Orders
Using Visual Studio 2010, I've ran a 'Find in Files' for sp_Orders
so I can find all occurances of Type
and remove them.
However, not all executions of sp_Orders
make use of Type
so I'm now manually going through every occurance to see if it exists, and remove it.
I开发者_StackOverflow中文版s there a quick way of finding all occurances of sp_Orders
where the field Type
is used?
I don't think that there's a quick way to do this. The quickest way would have been to centralise these calls when first written, but there you go...
精彩评论