Answer Posted / suri

C and C++

What is use of dbcc commands?

620

---

What are the basic features of a trigger in ms sql server?

565

---

What is cdc in sql server?

562

---

How to modify an existing stored procedure in ms sql server?

521

---

Why we use the openxml clause?

532

---

---

What is a hint?

575

---

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

507

---

How to create a user to access a database in ms sql server using "create user" statements?

517

---

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

571

---

When you use @@error and try-catch?

567

---

What is multi-statement table-value user-defined function?

530

---

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

592

---

How to display a past time in days, hours and minutes?

563

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

472

---

What is the purpose of a table?

511

---