Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

Free SQL Server Webcast > Building Really Fast SQL Server VMs
 

SQL Server 2012 Cycle Clipboard Ring Feature


By:   |   Read Comments   |   Related Tips: More > SQL Server Management Studio

Problem

While looking through the new features and improvements in SQL Server 2012, we found a potentially interesting feature namely Cycle Clipboard Ring. This feature is very useful especially when someone needs to copy several lines of scattered code from one T-SQL file to another. This feature has been long overdue in SQL Server Management Studio as Microsoft released this feature in Visual Studio 2003. In this tip we will take a look at how to utilize the Cycle Clipboard Ring Feature of SQL Server 2012.

Solution

Let us go through the steps to use the Cycle Clipboard Ring feature of SQL Server 2012.

1. In the SQL Server Management Studio (SSMS), click Edit -> Cycle Clipboard Ring from the drop down list as shown in the screen shot below. You can also access the Cycle Clipboard Ring Feature using the "Crtl+Shift+V" shortcut.

using cycle clipboard ring in sql server denali

2. In SQL Server Management Studio copy and paste the T-SQL code below in a new query window.


/* First Text to Copy in Cycle Clipboard Ring */
Use master
GO
/* Second Text to Copy in Cycle Clipboard Ring */
SELECT 
  NAME
 ,COMPATIBILITY_LEVEL
 ,STATE_DESC
 ,RECOVERY_MODEL_DESC
FROM SYS.DATABASES
GO 
/* Third Text to Copy in Cycle Clipboard Ring */
SELECT * FROM sys.procedures
GO

in ssms copy and paste the t-sql code in a new query window

3. Go ahead and Cut / Copy each set of TSQL Code from the above example one by one. Remember, the last item which you have cut or copied into the Clipboard Ring will be the current item for pasting.

4. Open a new query window and use CTRL + SHIFT + V to paste the Cycle Clipboard Ring's current item to the current query window.

5. Repeatedly press CTRL+SHIFT+V to cycle through each entry within the Clipboard Ring until you find the one you would like to paste in the query window. Each time you press CTRL+SHIFT+V within SQL Server Management Studio it replaces the last entry you pasted from the Cycle Clipboard Ring with the one new one which you have copied / cut earlier.

Next Steps


Last Update:


next webcast button


next tip button



About the author
MSSQLTips author Ashish Kumar Mehta Ashish Kumar Mehta has been contributing to the MSSQLTips.com community since 2009 with over 60 tips.

View all my tips
Related Resources





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Learn more about SQL Server tools