Sunday, August 21, 2011

SSMS Tips

Comma separated string

There are many times where you want to convert list of values to comma separated string.  This can be achieved by simple File & Replace.

Make sure in File Options, you selected “Use: Regular Expressions” option.  The same you can do by replacing “\n” with “’,’” for string.  Note: you may need to add beginning and end quotes, after Find & Replace.

SQL Comma

Find in Files

Some time you may need to check for some dependency of a object, by checking all the DB Scripts stored in File System.  In such case you can make use of File in Files feature of SSMS.

Find

Scroll keyboard shortcut

When you want to scroll window text with out using mouse you can use Ctrl+Arrow Key short cut to scroll the window.

No comments:

Post a Comment

Managing SQL Role

Recently, we had a scenario, where we need a simple SQL Role which gets read access to bunch of views.  While it was easy to create the vie...