DZone Database Zone
Customizing the SQL Prompt Built-In Snippets: A Better 'ata' Snippet
Snippets are a great feature of SQL Prompt. They save coding time and introduce standards and consistency to the way you build code modules. They have multiple replacement points (placeholders) for parameters and you can invoke them easily and from an SSMS query pane.
SQL Prompt also comes with many useful built-in snippets, but sometimes, we need to do some customization work to add the functionality we need. As an example, how might we improve the ALTER TABLE ADD snippet, 'ata'?
No comments:
Post a Comment