You want to create a new table, named TestTable, in the temp database. This table should have three columns, Name,city and GroupName, and be of the same data type as those with the same name in the category. The new table should be populated with the column data present in the category table.

 Posted by Rajkatie on 6/30/2013 | Category: Sql Server Interview questions | Views: 5845 | Points: 40
Select from following answers:
  1. SELECT Name, city, GroupName INTO TestTable FROM category
  2. SELECT * GroupName INTO TestTable FROM category
  3. SELECT Name, city,GroupName INTO category FROM TestTable
  4. All Above

Show Correct Answer

Source: | | Alert Moderator 

Comments or Responses

Login to post response