Answer / Gyanish Kumar Singh

A subquery (also known as an inner query or nested query) is a SELECT statement that is nested within another SELECT, DML (Data Manipulation Language), or DDL (Data Definition Language) statement. It allows you to retrieve data from one table based on the results of another query. In SQL Server 2008 and later versions, you can use multiple subqueries in a single statement.

How is table type constraint applied to a table?

1 Answers  

---

What are points to remember while using the fillfactor argument?

1 Answers  

---

which database is best to use in oracle and sql server? explain reasons?

5 Answers   TCS,

---

What's new in sql management studio for sql server? : sql server management studio

1 Answers  

---

Can a cursor be updated? If yes, how you can protect which columns are updated?

1 Answers  

---

What are the different types of joins and what does each do?

2 Answers  

---

How to throw custom exception in Stored Procedure?

1 Answers   MCN Solutions,

---

Explain about sql server login?

1 Answers  

---

Why transaction is important?

1 Answers  

---

i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...

2 Answers  

---

Explain about merge replications?

1 Answers  

---

Tell me about normalization in DBMS.

1 Answers   Honeywell, Zomato,

---