All Pinky, no Brain
...life tricks us with moments when everything seems to go right, but these soon pass...
Pages
Home
All About Me
Friday, March 13, 2009
have you seen this cat...?
have you seen this cat
Friday, March 6, 2009
Copy existing SQL Table structure into a new empty table..? Easy...
Here's the SQL Server thing: I want to copy an existing table's structure, but not the data.
Here's thefix:
SELECT * INTO MyNewTable
FROM ExistingTable
where 0=1
... which will do exactly that! Nice. Thanks to
Josh
for that.
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)