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
- 4120 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 system scalar functions?
What is the boxing and unboxing concept in .net?
To which devices can a backup be created and where should these devices be located? : sql server management studio
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
what is the difference between a primary key and a unique key? : Sql server database administration
How to select true false based on column value in sql server?
What do you mean by an execution plan? How would you view it?
How do I port a number to sql server?
Do you know spatial data types - geometry and geography in sql server 2008?
How to create nested stored procedure?
How can i Relate Tables in SSIS
How does index makes search faster?
What are the difference between primary keys and foreign keys?
How can I change procedure name in sql server?
Why functions are used in sql server?
