Wants to achieve short cut with parameters not in End for efficient usage of shortcuts
I am facing issue with following section :
Tools --> Options --> Environment --> Keyboard --> Query Shortcuts
I am able to create shortcut for :
SELECT TOP 10 * FROM
Where i can keep table name in ssms and directly execute the query with shortcut assigned to the above query.
I want to achieve
SELECT TOP 10 * FROM (TableName) WITH(NOLOCK) ORDER BY 1 DESC
Now for this the TableName is parameter and, i don't find any way to use like this.