Answer / Mohammad Sartaj

A sub-query, also known as inner query or nested query, is a SQL statement that is nested within another SELECT, INSERT, UPDATE, or DELETE statement. The sub-query retrieves a set of records which are then used by the main query for further processing.

How can we delete Duplicate row in table?

1 Answers   Wipro,

---

What program is used to store the data source file?

1 Answers  

---

What is the most common type of join?

1 Answers  

---

What do you mean by SQL injection attack?

1 Answers   Ittiam Systems,

---

what's the difference between delete table and truncate table commands? : Sql server database administration

1 Answers  

---

Restore database SQL2000, SQL2012 Backup of base is created in Microsoft SQL Server 2000 - 8.00.2066, I can't restore on Microsoft SQL Server 2012 - 11.0.2100.60

3 Answers   IT Decisions,

---

How to start and end transact-sql statements?

1 Answers  

---

Explain Normalization and DE normalization

1 Answers   iNautix,

---

Do you know data definition language, data control language and data manipulation language?

1 Answers  

---

A trigger can reference objects outside the current database? State true or false.

1 Answers  

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

1 Answers  

---

How to recover from sql injection? : sql server security

1 Answers  

---