Quickest way to remove all references to a SQL field?
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...
加载中,请稍侯......
精彩评论