Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Saving SQL queries in .sql file -- What Program to Use?

  1. Oct 15, 2015 #1


    User Avatar
    Science Advisor
    Gold Member

    Hi all,
    I have some queries to do, which I want to save as an .sql file. What program can I /must I use to do this?

    I think I remember at some point using plain old Notepad to write the queries, since these are made
    of standard English commands, nothing too fancy. Would this work?
  2. jcsd
  3. Oct 15, 2015 #2


    User Avatar

    Staff: Mentor

    Yes, a .sql file is simply a text file.
  4. Oct 15, 2015 #3


    User Avatar
    Gold Member

    a .sql file is just a text file, but I would recommend mapping that extension to a text editor that does syntax highlighting at least. If it's Microsoft SQL, SQL Server Management Studio or Visual Studio are great and have autocomplete and all sorts of other great stuff.
  5. Oct 15, 2015 #4


    User Avatar
    Science Advisor
    Gold Member

    Problem is I don't have those programs.
  6. Oct 16, 2015 #5
    Notepad++ knows SQL syntax.
  7. Oct 16, 2015 #6
    gedit is my favorite.
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook