I have created and run a query in Management Studio Express. How do I save it so that I can run it again later?
In fact, does MSE have this capability?
Many thnaks
Click on Save as, Type in a Filename like Query1.sql, hit Save.
At next time when you will use this Query, click File open, select youre prior saved File and you can use it again.
Servus
Klaus
Actualy, it appears that I have to create a View and save that.
Regards,
Andrew
|||Hi Andrew,
Saving to a file in MSE will save the script as an independent file that you can open later in MSE. A View is a specific object that is saved inside a database. Either can be used again, but their context is different.
Regards,
Mike Wachal
|||The problem is that the "Save" option is inactive (greyed out).
How do I activate t?
Thanks.
No comments:
Post a Comment