October 24, 2014 at 4:58 pm
Very, very simple question here. I'm using SQL Server 2014 Developer Edition, to improve on my SQL skills. I'm using to saving my SQL code in a folder under Documents\SQL Server Management Studio\Projects, but I don't see that after installing SQL Server 2014. Instead I see a folder Documents\SQL Server Management Studio\Code Snippets with two folders there, one named SQL and the other named XML.
So is this the replacement default location for storing your SQL or XML code?
And if I go into the SQL folder I'll find another folder there named My Code Snippets. Is that where we're supposed to place our SQL code, or is My Code Snippets used for something more specific?
Rod
October 26, 2014 at 10:48 am
Hi Rod,
The Code Snippets directory doesn't replace the projects directory. It holds custom code snippets you can develop for common routines you do every day.
For example, I run a query that shows me the running queries in the system a few times a day, so I wrote a snippet for it. Your custom code snippets will sit under the My Code Snippets directory.
I wrote a long post about it here:
http://www.dbnewsfeed.com/2012/07/27/sql-server-2012-snippets-for-download/
Regarding the Projects directory, I didn't know it was gone until you mentioned it. Not sure why it was vanished..
October 27, 2014 at 3:11 pm
Thank you, Matan, for filling me in as to what the code snippets folder is in SQL Server 2014 (and apparently 2012 as well). After reading your blog post I realize that it does remind me of the same concept in Visual Studio. Like you, I don't know why the Projects folder is gone now under SQL 2012/2014. I think I'll create my own and put the .sql file I just created, into it. Because I now realize I've kind of messed things up by saving what really isn't a code snippet, into the Code Snippet folder.
Rod
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply