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
- 3262 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
how many layers of tcp/ip protocol combined of? : Sql server database administration
How to verify the port number of the sql server?
What is 5nf in normalization form?
How to change the ownership of a schema in ms sql server?
What is report subscription?
What are scalar functions?
‘Order by’ is not allowed in a view how can you sort information from a view?
Why use view instead of a table?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
Explain the categories of stored procedure?
What does it mean to invest in the index?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
What is a recursive stored procedure in sql server?
How to create nested stored procedure?
