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 |
What is the use of “join” in sql server?
If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?
What is Cross Join
What is clustered primary key?
What is database architecture? : SQL Server Architecture
Is sql server is free?
Do you know how to make remote connection in database?
What are audit control procedures?
0 Answers Ernst Young, Thomson Reuters,
Why is DML provided?
1 Answers Ernst Young, Thomson Reuters,
What does Master database contains?
What are the lambda triggers?
How will you monitor replication latency in transactional replication? : sql server replication