Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Running SQL Scripts from the VS.NET interface
Message
De
11/01/2003 18:01:16
 
 
À
11/01/2003 14:09:30
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Divers
Thread ID:
00739631
Message ID:
00740712
Vues:
14
Hi Claudio,

Do you have Query Analyzer? I prefer to run all my scripts there.

~~Bonnie



>>Hi Claudio,
>
>Hi, Cathi! :)
>
>>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.
>
>yup. I found that. However, I don't want to create a SP. What I actually want is the ability to open a .SQL script file and run it through VS.NET IDE. I saw that I can create a new Database Project, and then create a new query... but that's too many steps.
>
>Let me explain a little better:
>
>If I double-click a .SQL file in Windows Explorer, it'll run VS.NET, as it's set as the default program for this extension. VS then open my file, but I'm not able to run it. That's what I'd like to do. :)
>
>Tks anyway for taking your time! ;)
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform