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 |
|
sagavb
Starting Member
18 Posts |
 Posted - 2009-05-29 : 06:45:26
|
| Hi,how to create a new table from an existing table along with its records?RegardsSaga |
|
|
sagavb
Starting Member
18 Posts |
Posted - 2009-05-29 : 06:47:25
|
quote:
Originally posted by sagavb
Hi,how to create a new table from an existing table along with its records?BUT WITHOUT USING "INTO"RegardsSaga
|
 |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-05-29 : 07:00:48
|
quote:
Originally posted by sagavb
quote:
Originally posted by sagavb
Hi,how to create a new table from an existing table along with its records?BUT WITHOUT USING "INTO"RegardsSaga
with out into meansu have to create the a table having same structure as existing table and insert that tabledata into newtable |
|
|
|
sagavb
Starting Member
18 Posts |
Posted - 2009-05-29 : 07:06:03
|
Yes.Select * INTO newtable from existingtableIs there any other way to create a table with same structure and data from an existing table?RegardsSagaquote:
Originally posted by bklr
quote:
Originally posted by sagavb
quote:
Originally posted by sagavb
Hi,how to create a new table from an existing table along with its records?BUT WITHOUT USING "INTO"RegardsSaga
with out into meansu have to create the a table having same structure as existing table and insert that tabledata into newtable
|
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-05-29 : 07:11:20
|
Select * INTO new_table from existing_tableis exactly what you need to the job.I cannot understand why this should be done without using INTO 
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-29 : 07:22:55
|
Oh, SagaVB has asked a number of question recently regarding easy things.But by NOT using the obvious tools.I asked him if this was home work questions, and he said yes.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=126698
E 12°55'05.63"N 56°04'39.26" |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-05-29 : 08:08:11
|
And? Could yo talk to his professor?
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
Creating table