CREATE a table from another table

Answer Posted / narendra

select *into newtable from oldtable.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

524


What is row_number () and partition by in sql server?

516


how many triggers you can have on a table? : Sql server database administration

486


Can you explain what is sql server english query?

534


What are the difference between primary key and unique key? : sql server database administration

517






What is the use of toad or sqldbx.?

711


What are indexers?

616


Explain following error properties?

551


Why I am getting "the microsoft .net framework 2.0 in not installed" message?

504


Explain what are the events recorded in a transaction log?

545


Can a cursor be updated? If yes, how you can protect which columns are updated?

508


What is ms sql server reporting services?

501


Explain what are the basic functions for master, msdb, model, tempdb databases?

524


Explain optimistic and pessimistic concurrency?

533


How would you go about developing a ssrs report?

110