You can not use the ALTER TABLE statement in SQL Server to rename a column in a table. You can however, use the sp_rename stored procedure if you do not
There are a lot of layout settings that help you define the page layout for printing???background, margins, etc. The Print area option allows you to select a certain area to
You can use the following snippet to quickly find out a column’s name. COL_NAME accepts two parameters: TableID and the ordinal position. SELECT COL_NAME(object_id(‘waybill’),2) AS col_name ? Visit the DevX
It can become quite frustrating when you cannot remember the name of an SQL stored procedure, especially if you have quite a few of them. But, let’s say that you
Use the GetLeftPart method on the HttpRequest’s URI with Authority as the UriPartial’s value to retrieve the DNS Name. string dnsName = HttpContext.Current.Request.Url.GetLeftPart(UriPartial.Authority); ? Visit the DevX Tip Bank ?
ASP.NET websites need some static data to be initialized, so that subsequent requests can utilize the loaded data and load much faster. It is a common practice to write such
During testing or monitoring, there is a constant need to monitor the number of sessions created, so as to better correlate the performance metrics collected. The Performance Monitor tool is
There are cases in our math calculations where we would need absolute values of negative numbers. System.Math class’s Abs method helps in such cases. It returns the absolute value of
A lot of time is spent on navigating in the HTML View of ASP.NET Pages that have too much HTML to find some little details. Visual Studio 2005 IDE provides