开发者

Quickest way to remove all references to a SQL field?

开发者 https://www.devze.com 2023-03-25 00:32 出处:网络
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

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...

0

精彩评论

暂无评论...
验证码 换一张
取 消