How can we help you today? How can we help you today?
OverAchiever
I use snippets very similarly to Tim - i.e., i don't much use the built-in snippets, but I do:  - convert my own heavily re-used/re-issued 'commands' into scripts/snippets and - commonly 'interleave' SQL Prompt snippets with t-sql template paramters (i.e.,CTRL+SHIFT+M) - as that provides me with the 'idiomatic' syntax AND the ability to quickly/easily 'customize' or parameterize on the fly.  And, when I say 'idiom' - I'm referring to how Ken Henderson used the term in his Guru's Guide to SQL Server Sprocs/etc. where his idea/goal of an 'idiom' was to find the most-correct and most-succinct version of a set of commands/directives.  Or, in other words, if you look at how good 'scripters' work, they:  - initially start by issuing commands 'manually' or 'from scratch' until they gain enough comfort and familiarity with the most COMMON ways those commands are used to address their needs then,  - they save 'persisted' versions of those commands as SCRIPTS for easier re-use.  Seems to me that Tim and I are using this functionality more as a tool to help us with 'scripting' than as a dev tool/aid (though there's no reason it couldn't be used in that sense - obviously). My thought/idea being that if Redgate were to host an 'official' repo full of snippets, a great guiding principle or idea for those snippets would be that:  - they weren't just practical or 'time savers'  - they were idiomatic - i.e., representing a 'best of breed' approach to tackling what's being done (easier said than done, obviously).  And, if that were the case, it seems that such an endeavor/initiative would pair NICELY with current Code Analysis functionality and efforts. / comments
I use snippets very similarly to Tim - i.e., i don't much use the built-in snippets, but I do: - convert my own heavily re-used/re-issued 'commands' into scripts/snippets and- commonly 'interleave'...
0 votes