Into ManagementStudio Press CTRL + ALT + T
Create your folder > create your snippet (aka template)
C:\Users\username\AppData\Roaming\Microsoft\SQL Server Management Studio\12.0\Templates\Sql\yourfolder\yoursnippetname.sql
#SQLServerManagementStudio 2014# %AppData%\Microsoft\SQL Server Management Studio\12.0\Templates\Sql
#SQLServerManagementStudio 2012# %AppData%\Microsoft\SQL Server Management Studio\11.0\Templates\Sql
source - https://ctrlshiftb.wordpress.com/2010/03/01/snippets-for-sql-server-management-studio-ssms/
origin - http://www.pipiscrew.com/?p=3715 sqlstudio-create-snippets