Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Running SQL Scripts from the VS.NET interface
Message
General information
Forum:
ASP.NET
Category:
Other
Miscellaneous
Thread ID:
00739631
Message ID:
00739698
Views:
12
Hi Claudio,

In VS.NET, you can edit your SPs by using the Server Explorer. You just need to tree down and find your stored procedure to edit. Right-click on the SP and choose Edit Stored Procedure. You can also run SPs by right-clicking on the SP and choosing Run Stored Procedure. If there are any parameters, VS.NET will prompt for their values.

>Hi, all!
>
>In VS.NET, is it possible to open a .SQL file and run that with an F5, for example? Yes, make it behaves kinda like SQL's Query Analyzer.
>
>I know that I can run SPs from the Server Explorer, but it actually doesn't allow me to open the SP for editing and then run it from the editor.
>
>TIA
-----------------------------------------

Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.com
www.prenia.com
Weblog: blogs.prenia.com/cathi
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform