How to dynamically number rows in a SELECT Transact-SQL statement
support.microsoft.com/default.aspx?scid=KB;EN-US;q186133
Saved 29 times on del.icio.us, most recently in 2011.
More links tagged sqlserver
- SQL Injection Attacks by Example www.unixwiz.net
- Индексы. Теоретические основы. www.sql.ru
- SQL Server Memory Configuration and MemToLeave www.johnsansom.com
- sp_addlinkedserver (Transact-SQL) msdn.microsoft.com
- Information Schema Views (Transact-SQL) msdn.microsoft.com
- Download Details - Microsoft Download Center - Microsoft® SQL Server® 2008 R2 Best Practices Analyzer www.microsoft.com
- Data Types (Transact-SQL) msdn.microsoft.com
- SQL Server Books Online msdn.microsoft.com
- The curse and blessings of dynamic SQL www.sommarskog.se
- SQL Server Tables without a Clustered Index www.mssqltips.com
More links tagged sql
- ConnectionStrings.com - Forgot that connection string? Get it here! www.connectionstrings.com
- MySQL Cheat Sheet www.nparikh.org
- A Gentle Introduction to SQL sqlzoo.net
- Google Cloud SQL - Google Code code.google.com
- NOSQL Databases nosql-database.org
- Log Parser Plus - Log Parser Example Queries logparserplus.com
- Library of Free Data Models www.databaseanswers.org
- SQLite Home Page www.sqlite.org
- Sequel Pro — MySQL database management app for Mac OS X www.sequelpro.com
- SQL Injection Attacks by Example www.unixwiz.net
More links tagged rownum
- Ask Tom: On ROWNUM and Limiting Results www.oracle.com
- MySQL :: MySQL 5.0 Reference Manual :: 8.4 User-Defined Variables dev.mysql.com
- lishblog: Using ROWNUM in Oracle blog.lishman.com
- Selecting the first n rows with Oracle www.adp-gmbh.ch
- Displaying row number (rownum) in MySQL « Jim's Life jimlife.wordpress.com
- Ask Tom: On ROWNUM and Limiting Results www.oracle.com
- select * from depesz;» Blog Archive » rownum anyone? cumulative sum in one query? www.depesz.com
- Programmer's Cookbook: Using ROWNUM Properly for Pagination progcookbook.blogspot.com