An identity column in SQL Server cannot be of varchar datatype. However, we would want to have to have an identity column which is of alphanumeric datatype. We could get around this using computed column. In the following example, I am going to create an identity column, and a computed column which gets its value […]
It is quite simple to calculate running in SQL Server using Sub Query.
In the following example, I am going to hide the console window for 10 seconds and then bring it back.
Unlike in case of web controls such as checkbox, dropdownlist, radiobuttonlist etc, we cannot disable postback on buttons, linkbuttons and hyperlinks as they don’t have AutoPostBack property. In some cases, when some conditions are met, we would want to stop the page from being post back and keep the user on the same page. In […]
Products.xml: In the following example, I am going to do a wild card search on product name using XML LinQ API and little bit help from regular expressions. Usage: SearchProductByName(“road”);
Products.xml How to read all elements in an xml document? In the following example, I will list all the elements and their values from the products xml. How to search for nodes/elements based on attributes? In the following example, I am going to search for a product based on its ID attribute. Usage: SearchProductByID(680);