How to find out the list schema name and table name for the database?

0 Answers  

---

Explain what is row_number function?

0 Answers  

---

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 Answers  

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   HCL,

---

Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?

1 Answers  

---

---

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

0 Answers  

---

how to get the automatic backup of the database in the sql server

4 Answers  

---

What happens if the update subquery returns no rows in ms sql server?

0 Answers  

---

How can we use ConnectorJ JDBC Driver with MS SQL?

0 Answers   PUCIT,

---

Difference between drill down and drill through report.

0 Answers  

---

What are triggers in ms sql server?

0 Answers  

---

what is Full Text Search ?

1 Answers   TCS,

---