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
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
How to backup SQL Server Reporting Services ?
What is sub-query in sql server? Explain its properties.
How use inner join in sql server?
How to query multiple tables jointly?
How can you set the threshold at which sql server will generate keysets asynchronously?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
What is the native system stored procedure to execute a command against all databases?
How do I completely remove sql server instance?
What is the default value of an integer data type in sql server 2005?
Mention what are the different types of ssrs reports?
Explain the working of sql privileges?
optimization techinques
What are the different types of subquery?
Can the query output be sorted by multiple columns in ms sql server?
What is cursors? And what are the different types of cursor?