CODEWITHSUNDEEP
sql-server
Justin
Justin

Reputation: 11

Loading Queries in MS SQL Server Management Studio

How to execute queries saved to your PC?

If you're like me and you have just started using SQL Server with the SQL Server Management Studio and just created/saved a complicated query, you might be wondering how you can open and run that query at a later date.

For me, it wasn't completely apparent, but with a few minutes of searching and trial and error, I've found a simple solution.

If anyone else has other solutions please list them below. Thanks.

Upvotes: 0

Views: 552

Answers (2)

marc_s
marc_s

Reputation: 755491

Seems rather convoluted - what's wrong with just using File > Open > File??

enter image description here

Upvotes: 2

Justin
Justin

Reputation: 11

  1. Open the location of your saved query in your file explorer.
  2. Drag the desired query into the Microsoft SQL Server Management Studio.
  3. The query should automatically load into the viewport.

Upvotes: 1

Related Questions