Saving .sql queries as .sql text file

Question

Beginner's question: I am learning SQL and the book says 'SQL queries can be created as an SQL script which can be saved as a plain text file with a .sql file extension.' presumably this is done in Notepad but how do I save it as a .sql script please?

Answer 1

To save a file as sql file in notepad - save the file as "yourFile.sql" as in the below picture.

Make sure to select "All Types ." instead of "Normal text file (*.txt)"! Else it will be saved as script.sql.txt.