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 |
|
priyaram
Yak Posting Veteran
82 Posts |
 Posted - 2005-08-19 : 16:24:46
|
| i had taken a backup of all the tables in the databse and i truncated the rows of all tables after that.if there anyway i can restore only a single table from thta backupthanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-19 : 16:30:32
|
| No. SQL Server 6.5 allowed it, but the newer versions do not.But you can restore the database to a new name and then with your restored copy, use INSERT INTO SELECT * FROM NewDb.dbo.TableName to get the data back without having to restore over your database.Tara |
 |
|
|
priyaram
Yak Posting Veteran
82 Posts |
Posted - 2005-08-19 : 16:38:54
|
| or else i am having the same data in temporary table.from that temp table is there any way i can copy to the main tablewith in the same database |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-19 : 16:43:29
|
| Yes you can use INSERT INTO SELECT * FROM...Tara |
|
|
|
priyaram
Yak Posting Veteran
82 Posts |
Posted - 2005-08-19 : 16:46:23
|
| cal you pleazse give me the syntam.right now i am having 3 columns with same datatype on both tables.i have to copy from temp1 to temp2 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-19 : 16:55:52
|
| Look up INSERT INTO in SQL Server Books Online.Tara |
|
|
|
|
|
|
recover a table