what command is used to create a table by copying the
structure of another table?
Answers were Sorted based on User's Feedback
Answer / hokar
SELECT * INTO tabname1 FROM tabname2 WHERE 1=2 (TO copy
only the structure)
|Is This Answer Correct ?||17 Yes||4 No|
Answer / pradip jain
SELECT * INTO tblNew FROM tblOld WHERE 1=2
|Is This Answer Correct ?||7 Yes||0 No|
Answer / kumar.t
Select * into newnew1 from newnew WHere 1=2
|Is This Answer Correct ?||4 Yes||0 No|
Answer / jaydev
SELECT TOP 0* INTO tabname2 FROM tabname1
|Is This Answer Correct ?||5 Yes||3 No|
Answer / naik
select * into oldtable from newtable where oldtable
|Is This Answer Correct ?||2 Yes||1 No|
Answer / kunal sain
create table table_name
as select * from another_table
|Is This Answer Correct ?||7 Yes||8 No|
Answer / narsing
SELECT * INTO tabname1 FROM tabname2 WHERE 1<>2 (TO copy
only the structure)
|Is This Answer Correct ?||0 Yes||3 No|
ow to bring suspect mode datbase online from scratch
1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.
Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name
Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?
What is the difference between truncate and delete statement?
What is better - 2nd Normal form or 3rd normal form? Why?
1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks
How will you collect the date from current date to last older 6 days date in sql server 2005
What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename>
what is syntex second or third highest salary. thanks & Regards Dhirendra sinha
what is Equity join?
Normalization and denormalization