Showing related tags and posts accross the entire site.
-
In one of the website I have developed, we feature random products displayed on a webpart. This can be done several ways either of the code behind or via t-sql but I think the simplest way to do it is via t-sql with the help of Guid columns. Globally Unique Identifier or GUID is a randomly generated...
-
dwarvend, a former teammate in my frist company once asked me about data paging large resulsets in ASP.NET. Data paging in SQL Server 2005 is relatively easy with new RowNumber feature but supporting dynamic sorting is little tricky. I have this executable to script to demonstrate this sorting. --check...
-
When you are developing software product to be catered to diverse customers, it must be a standard to localized your software. With .NET this has never been easy, on .NET 2.0 its even easier with striongly typed resource files. But localizing application must be part of the architectture and should not...
-
Maybe some of us are used into copying results of our query and pasting it to Excel for further analysis or reporting, but we are also used into SQL 2000 behaviour. With Sql Server 2005 Management Studio, you can copy and paste the query results including the headers. Just goto, Query -> Query Options...