This query comes as an answer to the following tek-tips forum thread http://tek-tips.com/viewthread.cfm?qid=1672424 The task was to extract 7 digit numbers from a string. My solution is a simple straight-forward recursive CTE, although perhaps a bett

Though I know viewstate is vulnerable to security as it reveals sensitive information, I always thought that its reasonably difficult to decode. But i found that decoding viewstate is very much simpler. ASP.NET has a class "LosFormatter", by using which we

Recently i started to learn HTML 5, In which i found an interesting attribute "Placeholder", which can be used to show sample values for controls in web page. When the page loads, controls will have the value specified in "Placeholder" attribute. As soon a

Its Chrismas and New Year holiday time. Both Google & Microsoft seems to be playing same "Let it snow" competition. 1. Go to google.com and search for "Let it snow". Press enter. 2. Go to below URL. http://ie.microsoft.com/testdrive/perf

99.99% of the time, we write our code with zero indexed arrays. However, C# allows us to create non zero based (single or multi dimensional arrays). CreateInstance is a static method available in Array class. To understand the concept in a simple way, let'

Today I got an error in javascript because of "innerText" property. I found this property is not working in mozilla browser and working in other browsers. Later I found that innerText property is not compatible with mozilla browser and instead we can user

The DebuggerDisplayAttribute constructor has a single argument: a string to be displayed in the value column for instances of the type. This string can contain braces ({ and }). The text within a pair of braces is evaluated as the name of a field, property

Recently learned that when we write linq queries will be converted into corrosponding methods at runtime. Eg: [code] from c in customers group c by c.Country into g select new { Country = g.Key, CustCount = g.Count() } [/code] will be converted into

1) Transaction log are not recorded for table variables so they are transactional neutral or you can say that they are out of scope of transaction mechanism. Whereas temp tables participate in transactions just like normal tables 2) Table variables cann

Today I just learned from Rick strahl Blog we can get IIS Version using Server variable like [code] if (HttpContext.Current != null && HttpContext.Current.Request != null) { string osversion = HttpContext.Current.Reques