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 do you make a trace?

962


Does sql server 2000 full-text search support clustering?

822


Explain what are the authentication modes in sql server?

957


What is difference between count (*) and count 1?

871


What is a dataset and what are the different types of datasets?

129


Please explain go command in sql server?

1001


How to recover from sql injection? : sql server security

962


What is 2nf normalization?

978


Can primary key be null?

886


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

2337


Which trace flags are enabled in sql server?

953


What is database replication?

1086


How to provide default values to function parameters?

1064


Explain triggers?

953


Using the customer, and order table in northwind database, please write a query to produce xml?

1016