Sqlserver - fengzhimei

Remove duplicate rows from a table

摘要: Here is thething, if we have a table with the following structure, there are thousands of records in this table, and probably some of which is duplicated.Now weneed todelete those duplications by a sq...阅读全文

posted @ 2006-05-12 15:28 fengzhimei 阅读(583) | 评论 (0) 编辑

Backup or Restore SQL Server Database to another server.

posted @ 2005-06-22 14:51 fengzhimei 阅读(1364) | 评论 (0) 编辑

SQL Tip of the day: get a specific range of results

posted @ 2004-08-10 00:01 fengzhimei 阅读(1301) | 评论 (2) 编辑

Will you use cursor, loop or ???

posted @ 2004-07-04 14:55 fengzhimei 阅读(1742) | 评论 (2) 编辑

SQL Server Performance Tip : Row-by-Row Operations Without Cursors

posted @ 2004-07-04 14:18 fengzhimei 阅读(1309) | 评论 (0) 编辑