what command is used to create a table by copying the
structure of another table?

Answer Posted / kumar.t

Select * into newnew1 from newnew WHere 1=2

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are different types of raid configurations? : SQL Server Architecture

562


When does a workload on SQL Azure get throttled?

113


Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

508


What is 2nf normalization?

531


Explain optimistic and pessimistic concurrency?

533






What is the difference between index seek vs. Index scan?

566


What are wait types?

578


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

1711


How to add the custom code in Report?

97


explain different types of constraints? : Sql server database administration

509


How to list all field names in the result set using mssql_field_name()?

517


Explain what you mean by 3 tier architecture.

619


how to do partition in sqlserver

1962


List the ways in which dynamic sql can be executed?

630


How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

632