Good tip! SSMS 2012 is more like VS2010.

In SSMS 2K8 you can also use [Tab], [Delete] and perform clipboard operations after making [Shift] + [Alt] (rectangle) selections in the code editor.

I actively use this functionality. In fact, it is available within the Visual Studio shell, meaning that it is available in Visual Studio 2008 (whose shell is used by SQL Server 2008/R2) and Visual Studio 2010 (whose shell is used by SQL Server 2012).

@kingkong0924: That's because the SSMS inherently leverages the Visual Studio shell (same as BIDS).

The same result (1 -> SELECT 1 UNION ALL ...) can be obtained by using regular expressions in SSMS:

Step 1:

Ctrl H
Find what ^
Replace with SELECT_ 
check Use Regular Expressions
Replace All

Step 2:

Ctrl H
Find what \n
Replace with _UNION ALL\n
check Use Regular Expressions
Replace All

Note: _ means space

Source:

http://msdn.microsoft.com/en-us/library/ms174214%28v=sql.90%29.aspx

http://www.simple-talk.com/sql/sql-training/regex-based-finding-and-replacing-of-text-in-ssms/

Hei,really great tip...

@Bogdan Sahlean

Nice one.

With your comments, I came to know how to use regular expressions in Find&Replace option in SSMS.

This one is very useful in SQL 2008.

Thank you very much.

Gud tip..Thank you very much..

Hi Abishek,

Thanks for your tip, really nice one.