sql syntax completion code

Hi.
i trying to find if sql assistant can complete the basic TSQL keywords
like SELECT , BEGIN TRANSACTION and all the basic TSQL/SQL , and not only the objects defined in "list item" in options.
is there a way?
(i know in redgate sql prompt it give full intellisense of ALL keywords - not only the objects)

thanks.

Zahi.

There is currently no such feature. If you need assistance with keywords, you likely need a different kind of tool, something like graphical drag-and-drop query builder which will paste all keywords for you.

Regards, SysOp

thanks for your quick reply.

do you inted to add this feature in the future?

Maybe. I don't know for sure, but frankly I think that in any case that would be a very low priority enhancement because the impact on developer productivity is near zero, keywords are short and time taken to select them from a suggestion list is typically much longer then to finish typing them, not to mention that such selection requires similar number of keystrokes.

And secondary because many keywords are currently used to display history based suggestions, for example, when you type SEL you get a list of recent or most commonly used SELECT quires so that you can quickly pick and modify one of them rather then type the entire thing in full. This feature alone provides sometimes very significant time savings. If you just started using SQL Assistant, you may not be able to see that feature for a little while, until the historical queries cache is filled with some data.

yes, i saw the history.
but for spelling is very good to have that feature (like TRANSACTION or other big words)
and as you say for choosing the right keyword from a list - its time saving.
(you did all this hard work to all the objects , functions etc, so the basic keywords (you even have built in functions - so why not the basic ones?)
:-)

If you wish, you can add keywords to the Custom Assistance group of options and have them displayed when you press Ctrl+Space in any place

Open SQL Assistant options -> click DB Options tab -> click SQL Server assistance type on the left -> on the right expand Custom Assistance options group -> scroll down and find line [@@] -> before that line insert needed keywords, one keyword or keyword set per line -> Click Ok or Apply button to save changes.

Now if you restart target editors, in case they were running, you can start using new keyword suggestions. For example, if added the following lines to the Custom Assistance as described above

SELECT
SELECT * FROM
BEGIN TRANSACTION
BEGIN TRAN
ROLLBACK TRANSACTION
ROLLBACK TRAN
ROLLBACK

in the target editor press Ctrl+Space, type se, you should see SELECT and SELECT * FROM suggested in the popup list. Similarly if you type roll you are going to get 3 suggestions for ROLLBACK.

Thanx.

:-)