Late Night Dev

SQL Server 2005’s ROW_NUMBER ranking function allows you to accomplish pagination of your selected set of data.  You need to determine the row number so that you can select a subset of the data.  For instance, you may want to feature 5 articles on your web page.  The first article flagged as featured will be [...]

Do you need to retrieve some of your data in XML to take advantage of the ease of sharing data between systems or applications where a complex import procedure is not feasible or maybe you just need a quick and simple XML output. The for XML clause can be used retrieving data from your tables [...]