Vikram Lakhotia Blog on Asp.Net, Dot Net, SQL, VIsual Studio, C# etc

Hi,

One of the features that I use very regularly in Visual studio 2008 is the Open folder in Windows Explorer. Many a times we want to do something with the actual without the use of Visual Studio.

A common scenario is to change the connection string in the Web.config screen locally without checking in the Web.config file. What I do is go to the physical path and change the property of the file and make it editable.Now I open the file in a Notepad and update the connectionstring. This is many a times required to check for issues with different kind of data.

For cases like these I really like the feature of the visual studio on how easily I can open the working folder. All I need to do is click on the file (or project) right click (to get the context menu) and click on “Open folders in Window Explorer” to open the respective folder.

Thanks
Vikram

Hi,

Many a times we want to check if all the characters in a string are in capital letter or not? Doing this in Dot net is very simple. But what if this kind of checking neds to be done in SQL server. We all know SQL is not the best language to do these kind of checking.

Last Day I had to some similar kind of work. I created a small function to check if all the character in a string(username etc..) are in capital letter or not. Here is the function.

CREATE FUNCTION CheckIfAllCaps (@StringToCheck VARCHAR(500))
RETURNS bit
AS
BEGIN
   DECLARE @return BIT
   DECLARE @position INT

   SET @position = 1

   WHILE @position <= DATALENGTH(@StringToCheck)
   BEGIN