Archive

Posts Tagged ‘ssms options’

SQL Server – Displaying line numbers in Query Editor – SSMS

20.01.2014 No comments

You can enable line numbers to be displayed in SSMS Query Editor. This is extremely useful when working on a large module.

To enable line numbers in Query Editor windows, follow below steps:

Step1: Go to Tools > Options

image

Step2: In the Options dialog box navigate to Text Editor > Transact-SQL > General

image

Step 3: Check “Line Numbers” and click on “OK”

image

Now, when a query window is opened Line Numbers will be displayed:

image

Hope This Helps!

Vishal

SQL Server – Management Studio – Changing the default values for Select/Edit commands

05.08.2011 No comments

Management Studio provides a shortcut for selecting or editing top rows of a table. You can use this by right-clicking table in Object Explorer, and choosing appropriate option:

image

Select Top 100 Rows: This opens a new query for returning top 1000 rows from the table and executes the same.

Edit Top 200 Rows: Choosing this opens top 200 rows from the table in EDIT mode.

You can change these default values (1000/200)  to required values.

 

Changing Default Values for Select/Edit commands:

These default values can be changed from Management Studio Options:

1. Go to "Tools" Menu > Options,

2. Expand "SQL Server Object Explorer" node > Select "Commands"

3. Change the values as required:

image

4. Click "OK" to apply changes.

 

You should now be able to see modified values for these command in Object Explorer.

image

Hope This Helps!

Vishal