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
- 4110 Views
- I also Faced
- E-Mail Answers
Answer Posted / abhinay
select * into table_name from destination_table_name where 1=0
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
List some major differences between triggers and stored procedures?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
How do you size a resultset?
What types of replication are supported in sql server?
Explain what is use of dbcc commands?
How to execute a stored procedure in ms sql server?
What are the types of table?
How many types of keys are there?
What is data file in computer?
What is NOT NULL Constraint in sql server 2012?
List the data types available in mssql?
Do you know what is difference between index seek vs. Index scan?
Explain the cursor lock types?
What are page splits?
How do I trace a query in sql server?
