Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 4014 Views
- I also Faced
- E-Mail Answers
Answer Posted / raj sekhar
select empname,empage,empaddrs,empid,empbirthdate into
newemptable from oldemptable
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Explain what is dbcc?
Explain the creation and execution of a user-defined function in the sql server?
Explain about builtinadministrator?
What command is used to create a database in the sql server and how?
on line cluster can we make if yes tell me the procedure
what is the difference between Tabular and Matrix report?
Is the log file is a part of file group?
How secure is sql server database?
how to define testing of network layers? : Sql server database administration
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
Explain what is lock escalation and what is its purpose?
Why is normalisation important?
Do you have any idea about the tcl commands?
How do you check sql server is up and running?
