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

what command is used to create a table by copying the
structure of another table?

Answer Posted / pradip jain

SELECT * INTO tblNew FROM tblOld WHERE 1=2

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the tools available in market as an alternative to sql server reporting services?

121


What are partitioned views and distributed partitioned views?

988


How do you drop an index?

872


Find columns used in stored procedure?

942


What is transactional replication?

915


You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

1004


How do I start and stop sql server?

971


What are a scheduled jobs or what is a scheduled tasks?

863


Tell me what do you understand by a view? What does the with check option clause for a view do?

963


Explain database normalization?

1162


How to find Duplicate Records In table?

972


How can you ensure that the database and sql server based application perform well?

1024


What are the new data types are introduced in sql 2000?

864


What are the features of Embedded SQL

1083


What is query cost in sql server?

943