Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Search For Text in Stored Procedure
Message
De
12/08/2004 09:28:12
Evans Carl
System Answers Consulting, Inc
Big Lake, Minnesota, États-Unis
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00932509
Message ID:
00932671
Vues:
20
>Carl
>
>Thanks for the information. My problem is that I'm often searching a stored procedure to see if it is going to return a field I need or if I need to modify it. I have to scan the whole stored procedure instead of being able to use a "Find" function and type in the name I'm looking for. I've gotten so I copy the whole stored procedure, paste in in notepad and then do the Find. It works, but seems like MS just forgot that basic functionality that is in most window applications.

kirk,

If you open the Stored Procedure in Query Analyzer, then the Analyzer does allow you to do a CTRL+F find and CTRL+H find/Replace. I use it often because we have quite a few Stored Procedures that are very lenghty.


Carl
¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°¤º°`°º¤ø¤º°¤º°
Carl Evans
CEO & President
System Answers Consulting, Inc.
MCSD .NET, ASP.NET, C#.NET, VB.NET,
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform