Showing entries 1 to 1
Displaying posts with tag: SQL 2005 (reset)
Dec
06
2007
Creating Copies of Tables: MS SQL vs. MySql
Posted by David Holoboff on Thu 06 Dec 2007 20:27 UTC
Tags:

I was reminded the other day how SQL Server was annoying in regards to table structure changes. All I wanted to to was copy a table (with structure intact - keys, dependancies) with its data.How hard could that be?MS SQL in ActionFirst, I needed to do a complete DDL on TableOne and replace every instance of the word "TableOne" with "TableTwo". It works, even though it is bulky and takes time,

Showing entries 1 to 1