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

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How create table structure only from tableA to TableB if
TableA have some data?

Question Posted / anand.kv

Answer Posted / anand.kv

SELECT TOP 0 * INTO tableB FROM tableA

Is This Answer Correct ?    16 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

184

When would you use the stored procedures or functions?

947

What are data resources?

853

Explain system rowset functions?

937

what are the disadvantages of cursors? : Sql server database administration

970

Explain what is lock escalation?

988

What are the difference between clustered and a non-clustered index?

978

Does sql server 2016 have ssms?

911

Explain what are page splits? : SQL Server Architecture

1003

How to rebuild indexes with alter index ... Rebuild?

1033

How do we synchronize On-Premise SQL server with SQL Azure?

120

What is the difference between insensitive and scroll cursor?

1070

Can we use having clause without group by?

930

List some case manipulation functions in sql?

966

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1832