Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
You are creating a number of tables for your product database. You want to create a table based on the properties of the columns and the data contained in rows output by a particular query and new table must be automatically populated with the data that is generated by the query.
Which T-SQL statements would you use for this task ?
on 6/30/2013 | Category:
Sql Server Interview questions
| Views: 3723 |
Select from following answers:
SELECT . . . INTO
using this SELECT . . . INTO statement you will output from a select query to form the basis of creating a new table.
DROP TABLE statement to drop an existing table.
Show Correct Answer
< Previous :
You want to create a new table, named TestTable, i ...
Next > :
What is J.W.T ?
Comments or Responses
Login to post response
More Interview Questions by Rajkatie
What is J.W.T ?
What is MvcSiteMapProvider ?
You have been examining the contents of the product table in the temp ...
You want to create a stored procedure that outputs productNo,productNa ...
You need to create a subquery that retrieves one instance of each prod ...
Which of the following statements can you use to modify an existing st ...
What is IKVM.Net ?
What is PNaCl ?
Latest Interview Questions
In.Net which is the parent class to create all windows service?
What is infonomics?
how to change the database owner?
What is the maximum size of columns in a particular table?
How to convert server name to host name?
How can you detect the servername ?
How can you detect the host name and Ip address?
How can you detect the version properties?