|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Latest Answer : Right click table in SSMS > Script Table as > CreateYour question of "copy" infers that you want all the constraints. The example that you give doesn't fill the requierments. As you want the structure you would als ... Latest Answer : For example let us take emp table. query to delete duplicate row will be like thisDelete * from emp where Rowid not in (select max(Row id) from emp grop by all columns) ... Latest Answer : Normalization is the technique of breaking the complex tables into much understandable smaller one to improve the optimzation of the database structure. The concept of "Fucntional Dependancy" is followed in Second Normal Form (2NF) which means ... What is the difference among "dropping a tableâ€,†truncating a table" and deleting all records" from a table? 1)What is the maximum value that can be stored for a datetime field? a. Dec 31, 9999 b. Jun 6, 2079 c. Jan 1, 2753 d. Jan 1, 2100 2)What is the correct SQL syntax for returning all the columns from a table named "Persons" sorted REVERSE alphabetically by "FirstName"? a. SELECT * FROM Persons WHERE FirstName ORDER BY FirstName DESC b. SELECT * FROM Persons SORT REVERSE 'FirstName' c. SELECT * FROM Persons ORDER BY -'FirstName' d. SELECT Read Answers (3) | Asked by : samir khan 1. Types of Triggers in Oracle 2. Can we relate two different tables from two different users in ORACLE,PL/SQL? 3. How can I combine sequence with select statement which is used in another insert statement. i.e.Insert 4. if records are inserted into table without committing.How to refer to these values in a procedure? 5. when we need to use USING clause in the sql?For example in this below:SELECT emp_name, department_name Read Answers (1) | Asked by : lavanya How many column maximum we can add in one table and how many foreign key maximum we can use in one table? Read Answers (14) | Asked by : Rado mathan Kumar What is the code to create a table having a column named DATE, which takes date in the format dd/mm/yyyy, in SQL Server2000? Or any format of date. Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employee table and department table with employee having department no. Read Answers (11) | Asked by : laxman Write sql query for retrieving employee names from employee table who are having salary greater than Write sql query for retrieving employee names from employee table who are having salary greater than 5000 without using where clause? Read Answers (12) | Asked by : Ashok
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
