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...

How to a Query to copy data from on table to another table.

Answer Posted / rajdeep gupta

Hi there is a question copy only schema without data from
one table to another

INSERT INTO A1 select name,address from A2 WHERE 1 = 2

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How you can change a cross join into an inner join?

909


Which sql server table is used to hold the stored procedure script?

882


Do you know what are acid properties?

1018


What is the difference between index seek vs. Index scan?

971


Why we need to use secondry database file? though, we can do same work using primary database file also.

6752


How to change parameter value inside the report?

153


Why it is recommended to avoid referencing a floating point column in the where clause?

919


What are different types of replication in sql server?

1030


Explain syntax for dropping triggers?

885


How can you stop stored procedures from recompiling?

848


What is the use of commit?

954


How to find related tables in sql server?

871


What are sub reports and how to create them?

124


What is faster join or union?

1109


Is foreign key unique?

957