8

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?

Improve this question
4
  • save as filename.sql - done Commented Aug 2, 2015 at 8:05
  • 1
    change the file type to .sql , so the file name becomes filename.sql from filename.txt . Commented Aug 2, 2015 at 8:07
  • Hi Amand, thank you but I guess didn't make my question clear enough: when I have created the query in Notepad I want to save it as a .sql file but Notepad does not give me the .sql option in its list of 'save as' choices. Bw patrick Commented Aug 3, 2015 at 12:19
  • Thank you Amand. When I attempt to Save As the notepad document, .sql is not a saving option. BW Patrick Commented Aug 3, 2015 at 12:22

1 Answer 1

Reset to default
5

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.

Screenshot of how to save sql file from notepad

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.