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

[WWGD]

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?
Thanks.

 

[jtbell]

Yes, a .sql file is simply a text file.

 

[DavidSnider]

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.

 

[WWGD]

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.

Problem is I don't have those programs.

 

[willem2]

Problem is I don't have those programs.

Notepad++ knows SQL syntax.

 

[newjerseyrunner]

gedit is my favorite.