Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

CREATE a table from another table

Answer Posted / narendra

select *into newtable from oldtable.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1963


Does a specific recovery model need to be used for a replicated database? : sql server replication

961


What is the syntax for encrypting a column in SQL Server?

1119


What is sql server database?

1006


Does view occupy space?

941


How do you open a cluster administrator?

1049


How to convert numeric values to integers in ms sql server?

1089


How can we delete Duplicate row in table?

1058


What do you understand by intent locks?

1008


What are the fixed server level roles? : sql server security

1125


Can a table have 2 primary keys?

981


What is Federation Root Database?

104


What is used to replicate sessions between instances in coldfusion clusters?

1071


How to write character string constants or literals in ms sql server?

1019


What programming language would you use to create embedded functions in ssrs?

184