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 create table structure only from tableA to TableB if
TableA have some data?

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

Do you know nested transaction?

998


Explain the working of sql privileges?

1143


What is the difference between a check constraint and a rule?

1346


Why do we use stored procedures in sql server?

997


What is the Control Flow in SSIS

1144


Find columns used in stored procedure?

1034


What is the difference between lock, block and deadlock? : sql server database administration

1088


What to perform pattern match with the like operator?

930


What is plan freezing?

1010


What is difference between createstatement and preparedstatement?

1172


Define views.

1068


What are pessimistic lock and optimistic lock?

1139


How to remove duplicate rows from table except one?

1061


Explain having clause and where clause?

1092


What is the difference between cube operator and rollup operator? : SQL Server Architecture

1169