Is there any plugings or text editor to auto-complete SQL statement? I am using SQL Server Management Studio (ssms) 90% of time, but most of time I have to type SELECT FROM WITH(NOLOCK) WHERE blahblah. Trying to find a more efficient way. Thanks.
+5
A:
try SQL Prompt
As you type SQL Prompt provides unobtrusive support, suggesting appropriate keywords, tables, views, and other database objects. It even suggests complete join conditions based on foreign key constrains or matching column names. Where it makes sense SQL Prompt will complete entire statements for you, such as INSERT or ALTER VIEW.
RRUZ
2010-04-29 03:41:03
+6
A:
Sql Prompt from redgate or built in in SQL 2008. However the latter is a pale imitation of the redgate addin
Preet Sangha
2010-04-29 03:42:10
Absolutely. It's the dog's dingle. It even has a 'cut down' version of SQL Refactor (another of red-gate's tools) which makes your code more readable.
adolf garlic
2010-04-29 07:23:58
Also, don't bother upgrading to SSMS 2008 for the autocomplete. It is truly dreadful, esp when you've used SQL Prompt. Customer service from Red-Gate is excellent too. Go and buy it now!!
adolf garlic
2010-04-29 07:25:17