Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Administration, SQL Puzzles Rss

   Items 1 to 3 of 3   
 

Just For Fun: An Impossible Delete

How can you delete only some duplicates? Without Identity's, Temp tables, Cursors, loops or ROW_NUMBER()? Would you believe, go back to the 70's?  Read more...
By RBarry Young 2009/10/30 (first published: 2008/08/05) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 32,090 reads

Just For Fun: An Impossible Delete

How can you delete only some duplicates? Without Identity's, Temp tables, Cursors, loops or ROW_NUMBER()? Would you believe, go back to the 70's?  Read more...
By RBarry Young 2009/10/30 (first published: 2008/08/05) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 32,090 reads

SQL 2000 DBA Toolkit Part 4

In the final installment of his series, Michael Coles examines a few other functions in his SQL Server 2000 toolkit to help you with other functions, like reading a directory on your server. Read the series and send some feedback to make this THE premier toolset for SQL Server 2000 DBAs.   Read more...
By Michael Coles 2006/05/04 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 14,007 reads
   Items 1 to 3 of 3   
 
Tags
t-sql (2)    
sql server 7 (1)