You are here:Home » tsql » Cycle Clipboard Ring - Interesting Feature of SQL Server Denali

Cycle Clipboard Ring - Interesting Feature of SQL Server Denali

SQL Server 2011 introduced with new and best feature. This new feature is "Cycle Clipboard Ring".

Using this feature we can copy multiple texts and pate it sequentially with Ctrl + shift + V. Very amazing feature. Lets look on the below shots.



-- First I am copying this text only
USE MASTER
GO

-- Second I am copying this text only
SELECT
name, 
database_id,
compatibility_level, 
state_desc,is_read_only
FROM SYS.DATABASES 
GO

-- Third I am copying this text only
SELECT 
* 
FROM 
SYS.OBJECTS
GO

Now these three copied items are on the clipboard and you can paste in sequentially.

To paste first item which you copied, press Ctrl + Shift + V  1 time .
To paste second item which you copied, press Ctrl + Shift + V  2 times .
To paste third item which you copied, press Ctrl + Shift + V  3 times .

Please try with above example and enjoy clipboard items!