Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
anttitmh
Starting Member
1 Post |
 Posted - 2007-10-31 : 04:34:43
|
| Hi,I need to add columns to Table1, names and datatypes should match columns in Table2 (not all columns will be copied). How do i accomplish this? Is there a way to execute ALTER TABLE with Select query? |
|
|
PeterNeo
Constraint Violating Yak Guru
357 Posts |
Posted - 2007-10-31 : 06:33:15
|
| No, there is no way. U should use ALTER TABLE statements. |
 |
|
|
mr chuwit
Starting Member
1 Post |
Posted - 2009-10-27 : 17:22:57
|
| YOU!!! WHERE YOU GO? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-10-28 : 02:58:58
|
quote:
Originally posted by mr chuwit
YOU!!! WHERE YOU GO?
What do you mean?MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
copying columns from one table to another