Tuesday, March 25, 2008

Open multiple instances of Acrobat Reader

In order to start multiple instances of acrobat reader run it using following command:

acrobat /n

Friday, January 18, 2008

Get list of all stored procedures in SQL Server 2005

USE

SELECT NAME
FROM SYS.OBJECTS
WHERE TYPE = 'P'

Friday, January 11, 2008

Concatenate a double quote in Excel formula

Recently I faced a challenge to concatenate a double quote in the string. The formula =CONCATENATE(""",A1,""") did not worked. After some research I found out that it can be entered as

=CONCATENATE("""",A1,"""")

and bingo! it worked...