hw you create table in sql using existing table and variable
should be in specific order given ex : in old table empid
empname empsal empage empbirthdate empaddrs like is there in
new table we need it as EX: exmpname empage empaddrs empid
empbirthdate like we want hw we create this as a table not
view or nt reporting
Answers were Sorted based on User's Feedback
Answer / raj sekhar
select empname,empage,empaddrs,empid,empbirthdate into
newemptable from oldemptable
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / abhinay
select * into table_name from destination_table_name where 1=0
Is This Answer Correct ? | 0 Yes | 3 No |
Can sql servers link to other servers?
how to generate XML out of QUERY?
How will you find out if there are expensive SQL statements running or not?
What is the purpose of data source?
How can you ensure that the database and sql server based application perform well?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
What is Primary key and foreign key? Give an example
Explain about Joins?
What is row_number () and partition by in sql server?
What is triggers and its types?
Can we use where clause with group by?
Will count(column) include columns with null values in its count?