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
- 4072 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
Define Business Edition in SQL Azure?
When would you prefer to have a minimum number of indexes?
What is the difference between stored procedure and functions?
how will add additional conditions in sql?
What is the difference between a function and a trigger?
What is BCNF? How is it better than 2NF & 3NF?
How to use order by with union operators in ms sql server?
what are the different types of replication you can set up in sql server? : Sql server database administration
How is sql server used?
How can I get data from a database on another server?
Can coalesce return null?
Can you explain what is sql server english query?
What are pessimistic lock and optimistic lock?
What is mscorsvw.exe - process - microsoft .net framework ngen?
How do use Having,Group by,Group function in SQL?
