AutoComplete option in SQL Server 2008 [Resolved]

@Amatya Sir,

From SSMS 2008 onwards, we have the IntelliSense feature.It provides internal metadata and a list of available objects and properties while writing T-SQL queries.

The below are the steps to follow for the same

Step 1: Go to Tools -> Options -> Text Editor -> Transact-SQL -> IntelliSense and make sure the Enable IntelliSense checkbox is checked

Step 2: To verify that it is enabled, go to the Query menu and check that IntelliSense is enabled. Alternatively, the short cut key for the same is Ctrl+Q, Ctrl+I

Alternatively, if your are looking for some 3rd party effective tool, you can try with

a) dbForge SQL Complete (https://www.devart.com/dbforge/sql/sqlcomplete/ ) . A free edition is also available.

b) The SQL Developer Suite from RedGate(http://www.red-gate.com/products/sql-development/sql-developer-suite/ ). A 14days trial version is available.

Hope this helps

--
Thanks & Regards,
RNA Team

Amatya, if this helps please login to Mark As Answer. | Alert Moderator

If you are ok with using Third Party Tools then you can take a look Apex SQLComplete.

http://www.apexsql.com/sql_tools_complete.aspx

Thanks,
A2H
My Blog

Amatya, if this helps please login to Mark As Answer. | Alert Moderator

Dear Rajnilari2015.. Step 1 is ok.. but where i can get Query menu in SQL Server Management Studio 2008

The scenario is when i am typing select statement... after typing se it should show select and set option in the Query window...

Feel free to share informations.
mail Id ' adityagupta200@gmail.com
Thanks

Amatya, if this helps please login to Mark As Answer. | Alert Moderator