The alternative is, to pass an additional parameter when Null is selected, based on the flag you can call different queries. Yes, you need to write two different queries. Either...

If it was the nChar then length would be 60 othere wise it would take double the size of the character stored in the variable.

I got the different result sets in SQL 2005 and 2008. In 2005, I always getting output (1,1) whether it is a new (first) connection or new query window is...

The question ask only for those employees Who joined in the month of Jan, Feb, March, April, May, Aug from table employee having a field of join_date where as the...

Hi Dinesh,

I will appreciate, if the steps has been given for adding to GAC. This will be helpful for all if one don't have or have little knowledge on GAC