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
- 4199 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
can SSRS reports Cache results?
what is a check constraint?
How do you use a subquery to find records that exist in one table and do not exist in another?
How except clause is differs from not in clause?
What is the difference between stored procedure and functions?
can you instantiate a com object by using t-sql? : Sql server database administration
What's the information that can be stored inside a bit column?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
How to create a dml trigger using create trigger statements?
Can sub report data source be different from that of the parent report?
How would you go about developing a ssrs report?
What are the different types of stored procedures?
What does REVERT do in SQL Server 2005?
‘Order by’ is not allowed in a view how can you sort information from a view?
What are the default system databases in sql server 2000?
