why intellisense doesn't show in a merge sentence?[sqls08developer]

Question

recently i found merge is pretty awesome,with insert/update/delete sealed in one.

one thing bugs me there is no hints showed from the intellisense,who worked well in any other sentence.

why?somebody help pls

Answer 1

Here is a connect item on this issue:

SSMS IntelliSense does not suggest column names for MERGE statements

---

Krishnakumar S

Answer 2

MS doesn't support intellisense for MERGE atleast in the current  release, Here is the connect item and MS reply

http://connect.microsoft.com/SQLServer/feedback/details/733722/ssms-intellisense-does-not-suggest-column-names-for-merge-statements

Regards
Satheesh

Answer 3

Here is a connect item on this issue:

SSMS IntelliSense does not suggest column names for MERGE statements

---

Krishnakumar S

thanks a looot,

so there's no easy way out of this,guess nothing's perfect

Answer 4

MS doesn't support intellisense for MERGE atleast in the current  release, Here is the connect item and MS reply

http://connect.microsoft.com/SQLServer/feedback/details/733722/ssms-intellisense-does-not-suggest-column-names-for-merge-statements

Regards
Satheesh

this answer is the same as the above, first answer first served,still helpful,thanks a lot,

Answer 5

this answer is the same as the above, first answer first served,still helpful,thanks a lot,

So Stiffin, if Satheesh's answer is also serve the purpose you can mark that one also as an answer. There is no first-come-first-serve basis here. You can mark any thread as answer if you feel it answers the question.

---

Krishnakumar S

Answer 6

thanks from a rookie

Answer 7

As pointed out by others Microsoft's implementation of intellisense has its limitaitons.

There are actually alternatives. Red Gate offers SQL Prompt. I have never tried it myself, as I'm not a fan of intellisense in general, but I know that some people prefers it over what Microsoft ships. You can get an evaluation version from
http://www.red-gate.com/products/sql-development/sql-prompt/

---

Erland Sommarskog, SQL Server MVP, [e-mail]

Answer 8

As pointed out by others Microsoft's implementation of intellisense has its limitaitons.

There are actually alternatives. Red Gate offers SQL Prompt. I have never tried it myself, as I'm not a fan of intellisense in general, but I know that some people prefers it over what Microsoft ships. You can get an evaluation version from
http://www.red-gate.com/products/sql-development/sql-prompt/

---

Erland Sommarskog, SQL Server MVP, [e-mail]

Thx,i had digged into some stuff to find that it actually works prety good,This promt u talk about provides not only suggestions including both column name and statement structure but also an access to table structure\proc management,etc.My friends at work found a crack vision of it,working well with sql,and vs,really impressive,considering to apply for an authorized vision to my corp after the exploitation

Answer 9

I don't know what you mean with "crack vision", but if you are alluding that you are using the software without paying for it, this is where our friendship ends. Red Gate is a company that makes several good tools, and do a lot of benefit for the SQL Server community. If you like SQL Prompt and use it, you should pay a license, period!

---

Erland Sommarskog, SQL Server MVP, [e-mail]