Answer / Bharti Kathuria

Resource Database (RESOURCE_DATABASE) is a system database in SQL Server used to store metadata and resources shared among other databases. It contains system tables and objects that are essential for the proper functioning of the SQL Server instance.

How to convert binary strings into integers in ms sql server?

1 Answers  

---

What is trigger ?

7 Answers   Cap Gemini, SQL,

---

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

7 Answers   IBM, TCS,

---

Define normalisation?

1 Answers  

---

What is dml command?

1 Answers  

---

Differences between logshipping and mirroring

1 Answers   Microsoft, Syntel,

---

What are different types of subquery?

1 Answers  

---

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1 Answers  

---

How to skip remaining statements in a loop block using continue statements?

1 Answers  

---

What are the properties and different types of sub-queries?

1 Answers  

---

What is de-normalization in sql database administration? Give examples?

1 Answers  

---

Can you index views?

0 Answers  

---