February 27, 2006

Add Line Numbers in Your VS.NET Code Window

Go to VS.NET—>
Tools—>Options—>Text Editor

Choose the language and select the Line Number checkbox.

February 15, 2006

UDF For Capitalising First Letter in SQL Server 2000

This is a User Defined Function that will capitalize the first letter of a character after a space.
Also lowercase all capitalized words.
'MY NAME IS ROSHAN' --> 'My Name Is Roshan'.
Usage Select Capitalise('MY NAME IS ROSHAN')


Capitalise (@String VARCHAR(255))
DECLARE @StringCount int
SET @string = LOWER(@string)
SET @string = STUFF(@string,1,1,LEFT(UPPER(@string),1)) --Capitalize
the first letter
SET @StringCount = 0
WHILE @StringCount < LEN(@string)
IF SUBSTRING(@string,CHARINDEX(SPACE(1),@string,@StringCount),1)
= SPACE(1)
SET @string = STUFF(@string,CHARINDEX(SPACE(1),@string,@StringCount)+1,1,SUBSTRING(UPPER(@string),CHARINDEX(' ',@string,@StringCount)+1,1))
SET @StringCount = @StringCount + 1
RETURN @string

February 14, 2006

me Telepathist ??

Hey believe me I can read your mind.
Think a small number
Double this number
Add 8 to the result
Divide the result by 2
Subtract the original number
Convert this into a letter of the alphabet. (1=A, 2=B, 3=C, 4=D, 5=E etc.)
Think of the name of a country which starts with this letter.
Think of an animal whose name starts with the country's second letter.

hahaha You are wrong actually there is no elephants in Denmark except some in the zoo..

Thank you friends for not thinking about ostrich in Dominica. Still you don't think I mastered the art of telepathy, then try this
Think a 3-digit number where the first and last digits differ by 2 or more...
"reverse" number, obtained by reading it backwards.
Subtract the smaller of these two numbers from the larger one.
Add the result to its own reverse.

Is it 1089 ?

February 13, 2006

3 = 2, am I right ?

-6 = -6

9-15 = 4-10

9-15+(25/4) = 4-10+(25/4 ) // adding 25/4 to both sides:

9+(25/4)-15 = 4+(25/4)-10 //Changing the order

//(this is just like : a square + b square - two a b = (a-b)square.)
//Here a = 3, b=5/2 for L.H.S and a =2, b=5/2 for R.H.S.

. ' . (3-5/2)(3-5/2) = (2-5/2)(2-5/2)

3 - 5/2 = 2 - 5/2 //Taking positive square root on both sides

3 = 2

February 02, 2006


I am really fed up, for the last three months working in production support. Code drops, bug fixing and installation on daily basis. Seriously thinking about changing the job. I don't mind even if it is as a waitor in the hotel, but the fact is that I will be a failure in that too. Let us c

Guest: Waiter!
Me: Hi, my name is Roshan, and I'll be your Support Waiter. What seems to be the problem?
Guest: There's a fly in my soup!
Me: Try again, maybe the fly won't be there this time.
Guest: No, it's still there.
Me: Maybe it's the way you're using the soup; try eating it with a fork instead.
Guest: Even when I use the fork, the fly is still there.
Me: Maybe the soup is incompatible with the bowl; what kind of bowl are you using?
Guest: A SOUP bowl!
Me: Hmmm, that should work. Maybe it's a configuration problem; how was the bowl set up?
Guest: You brought it to me on a saucer; what has that to do with the fly in my soup?!
Me: Can you remember everything you did before you noticed the fly in your soup?
Guest: I sat down and ordered the Soup of the Day!
Me: Have you considered upgrading to the latest Soup of the Day?
Guest: You have more than one Soup of the Day each day?
Me: Yes, the Soup of the Day is changed every hour.
Guest: Well, what is the Soup of the Day now?
Me: The current Soup of the Day is tomato.
Guest: Fine. Bring me the tomato soup, and the check. I'm running late now.
[Returns with another bowl of soup and the check]
Me: Here you are, Sir. The soup and your check.
Guest: This is potato soup.
Me: Yes, the tomato soup wasn't ready yet.
Guest: Well, I'm so hungry now, I'll eat anything.

after 10 minutes ......

Guest: Waiter! There's a gnat in my soup!

The check:
Soup of the Day . . . . . . . . . . . . . . . . . . $5.00
Upgrade to newer Soup of the Day. . $2.50
Access to support . . . . . . . . . . . . . . . . $1.00