Hi,
I have a large database in MSSQL 2005 (rows around 3,788,299 : size 4GB)
Two questions
1. SQL query ~ select top 100 * from [tablename], how do capture the next 100 record?
2. SQL query ~ delete top 100 from [tablename] --- MSSQL show me syntax error? How can I only delete the top 100 record?
thk.
View Complete Post