DotNet - published Database stories the latest published Database stories from DotNet http://dotnet.kick.sg/ en-us Atweb Publishing Ltd. http://backend.userland.com/rss DotNet - Singapore dotnet developers - technology sharing network 30 Generate INSERT SQL Statement from SQL 2008 Tool If you have to deploy your DB, you will know how useful it is. <br /><br /><br /><a href="http://dotnet.kick.sg/kick.aspx?url=http://blog.sqlauthority.com/2009/07/29/sql-server-2008-copy-database-with-data-generate-t-sql-for-inserting-data-from-one-table-to-another-table/"><img src="http://dotnet.kick.sg/Services/Images/KickItImageGenerator.ashx?url=http://blog.sqlauthority.com/2009/07/29/sql-server-2008-copy-database-with-data-generate-t-sql-for-inserting-data-from-one-table-to-another-table/" border="0" alt="kick it on DotNet" /></a> http://dotnet.kick.sg/Database/Generate_INSERT_SQL_Statement_from_SQL_2008_Tool.aspx http://dotnet.kick.sg/Database/Generate_INSERT_SQL_Statement_from_SQL_2008_Tool.aspx Tue, 04 Aug 2009 07:37:28 GMT How to delete duplicate rows with SQL This article is quite helpful to show the techniques &quot;How to delete duplicate rows with SQL&quot; <br /><br /><br /><a href="http://dotnet.kick.sg/kick.aspx?url=http://www.xaprb.com/blog/2006/10/11/how-to-delete-duplicate-rows-with-sql/"><img src="http://dotnet.kick.sg/Services/Images/KickItImageGenerator.ashx?url=http://www.xaprb.com/blog/2006/10/11/how-to-delete-duplicate-rows-with-sql/" border="0" alt="kick it on DotNet" /></a> http://dotnet.kick.sg/Database/How_to_delete_duplicate_rows_with_SQL.aspx http://dotnet.kick.sg/Database/How_to_delete_duplicate_rows_with_SQL.aspx Sat, 11 Apr 2009 03:58:21 GMT Five methods converting rows to columns in SQL 2005 This article shows the 5 techniques how to convert rows to columns in SQL 2005. <br /><br /><br /><a href="http://dotnet.kick.sg/kick.aspx?url=http://sqlserveradvisor.blogspot.com/2009/03/sql-server-convert-rows-to-columns.html"><img src="http://dotnet.kick.sg/Services/Images/KickItImageGenerator.ashx?url=http://sqlserveradvisor.blogspot.com/2009/03/sql-server-convert-rows-to-columns.html" border="0" alt="kick it on DotNet" /></a> http://dotnet.kick.sg/Database/Five_methods_converting_rows_to_columns_in_SQL_2005.aspx http://dotnet.kick.sg/Database/Five_methods_converting_rows_to_columns_in_SQL_2005.aspx Tue, 31 Mar 2009 15:35:23 GMT