20.6 Using Code Snippets for Fast Code Entry

SQL Assistant^TM's Code Snippets feature provides a way for you to insert ready-made snippets of code into your SQL scripts. To insert a code snippet, type the shortcut name of the snippet and then press Ctrl+Enter hot key.

HoneyMonitor comes with a number of ready to use code snippets. For example, if in a Editor you type ''sg'' without quotes and then press Ctrl+Enter hotkey, the following text will be inserted at the current caret position:

SELECT | 
FROM 
WHERE
GROUP BY
ORDER BY;

Ready to use snippets are listed below. At the moment, you cannot create your own code snippets, but only use the the built-in snippets. We plan to add the possibility to create custom code snippets in a future HoneyMonitor release. Please, send us your preferred snippets and suggestion, we are happy to add them!

Note: The vertical bar in the snippet code indicates where SQL Assistant^TM will place the editing caret after the snippet text is inserted into the editor.

20.6.1 Code Snippets List

del

		DELETE FROM |		
			WHERE

is

		INSERT INTO |
			( ) 
		SELECT  
		FROM  
		WHERE

iv

		INSERT INTO |
			( )
		VALUES ( )

sg

		SELECT | 
		FROM 
		WHERE
		GROUP BY
		ORDER BY;

sm

		SELECT max(|)
		FROM
		WHERE

upd

		UPDATE |
		SET 
		WHERE

---

Copyright © 2007 - 2009 HoneySoftware - All Rights Reserved

Submit feedback on this topic.