Ars Technica

SQL Server - Copy Table in Same Database

I need to copy a mass amount of tables in SQL Server to the same database (obviously renaming the tables). I need to include constraints, keys, indexes, etc, as well as data. (we need to copy an old ...
Ars Technica

SQL server bulk copy - can you make it ignore duplicates copying into table?

I'm doing some development on a dev server of ours for a site that's currently live on another server. They have their own server with a SQL Server database holding the data for the live site. So as ...
Houston Chronicle

How to Create a Table From Query Results in Microsoft SQL

If your business uses relational databases to store data, it helps to use the SQL SELECT command with the INTO clause to create new tables from query results. This method isn't ANSI-standard SQL, but ...
Visual Studio Magazine

Database Synchronization with the Microsoft Sync Framework

Use the Microsoft Sync Framework to synchronize data changes between SQL Server 2008 Standard, SQL Server 2008 Express and SQL Server Compact Edition 3.5. Despite the availability of wireless and ...