sql server - Auto-complete editor for SQL statement -

is there plugings or text editor auto-complete sql statement? using sql server management studio (ssms) 90% of time, of time have type select with(nolock) blahblah. trying find more efficient way. thanks.

sql prompt redgate or built in in sql 2008. latter pale imitation of redgate addin