"Press TAB to insert snippet"

PoppaRex

Hi all. New to this product. I am growing used to it but it will take me a bit longer. One feature(?) that i have trouble with... If my sql screen includes an "end" satement and i want to inset a snippet, there's a message box that pops up telling me that if i want to insert a snippet i shoud use the TAB key rather than the enter key, and the enter key just adds a new line.

Here's the condition. I have a snippet ssf which inserts "Select * from"

-- typing "ssf" here and using the enter key works normally
BEGIN
END
-- Typing "SSF" here i have a little yellow window prompt that says "Press TAB to insert snippet" and using the enter key adds a newline.


there are other scenarios but its all bizzare and seem to be related to where on the screen i am in relation to an end statement.

My options are set to use both tab and enter.

I did the following:
I removed the TAB option
closed SQL sver manager
relaunched SQL sver manager
checked the options (Still only ENTER selected.
Opened a window
typed ssf and the normal behavior ensured.
Typed "END" hit enter
Typed SSF and the yellow tab only box appears...

bug or am i doing something wrong?

Nothing critical as i just need to watch what i am typing, but it slows me down if i have to watch the screen.

Thanks!
Rob

Using v 4.0.3.12 with SQL Server 2005

Anu D

Many thanks for your post.

This happens because Management studio cannot parse the query hence SQL prompt behaves that way.

Instead if you type:

BEGIN	

SELECT * FROM <Table name>

END 

ssf 

And than press enter key it should work.

Kindly let me know your views on this.