SQL Server default for Select Top 1000 Rows

Question

Is there a way to get this to default to the following: order by Id descending, or ordering by row creation date descending?

Answer 1

No. The only property that can be modified is the amount of rows under Tools -> Options -> SQL Server Object Explorer -> Value for Select Top < n > Rows command. Please note you can also modify the Edit Top < n > Rows and Select Top < n > Audit records.

You could write a separate stored procedure, add it to your master database, and add a shortcut under Tools -> Options -> Keyboard -> Query Shortcuts. Then in Management Studio, you could highlight the name of the schema and table and run the shortcut. The stored procedure called could then do this for you. Below is a sample stored procedure that would accomplish this goal but orders by the first column instead of a specific column name. You can replace the 1 with a specific column name, but this is likely more flexible for your purposes.

CREATE PROCEDURE dbo.usp_Test_OrderByFirstColumnDesc
    @TableName VARCHAR(MAX)
AS

SET NOCOUNT ON;

DECLARE @SqlCommand NVARCHAR(MAX) = N'SELECT TOP 1000 *
FROM ' + @TableName + ' (NOLOCK)
ORDER BY 1 DESC';

PRINT @SqlCommand;

EXEC dbo.sp_ExecuteSQL @SqlCommand;