Thursday, October 23, 2003

Source: Geekswithblogs.net Main Feed Simple way to Remove Duplicate Rows from an Existing Table in SQL SELECT DISTINCT * INTO duplicate_table FROM original_table GROUP BY key_value HAVING COUNT(key_value) > 1 DELETE original_table WHERE key_value IN (SELECT key_value FROM duplicate_table) INSERT original_table SELECT * FROM duplicate_table DROP TABLE duplicate_table [Geekswithblogs.net Main Feed] 9:41:12 AM    trackback []     Articulate []

Source: WebLogs @ ASP.NET Typical IT Project :-). [WebLogs @ ASP.NET] 9:33:38 AM    trackback []     Articulate []

SOURCE: Erland Sommarskog has an interestng collection of articles on SQL. Worth a look ! This is a small collection of texts about some features in SQL Server that people frequently ask about in the newsgroups about MS SQL Server. Rather than being a FAQ with many questions with short answers, these are in-depth articles on some of my favourite topics The curse and blessings of dynamic SQL. How you use dynamic SQL, when you should - and when you should not. (Added June 2001, Updated May 2003) Arrays and Lists in SQL Server. Several methods on how to pass an array of values from a client to SQL Server, and performance data about the methods. (Added March 2003) Dynamic Search Conditions. How to write a stored procedure that permits users to select among many search conditions, using both dynamic and static SQL. (Added May 2003) Implementing Error Handling with Stored Procedures and Error Handling in SQL Server – a Background. Two articles on error handling in SQL Server. I have split the topic on two articles, so if you only want to learn how to implement your error handling you can start there. The background article is more of interest to intermediate and advanced SQL users. Both articles also cover ADO. (New! Added July 2003) How to share data between stored procedures. Different ways of passing sets of data between stored procedures. (Added July 2001, Updated May 2003) Connecting to MS SQL Server from Unix. A brief summary of what's available. Since I don't work with Unix myself, not extremely well-informed, but people have kept asking me about this. (Added Jan 1999, Last update March 2003)   [WebLogs @ ASP.NET] 7:09:37 AM    trackback []     Articulate []