Answer Posted / arvind rohit

SELECT IDENT_CURRENT('table_name') ;

What is pessimistic concurrency?

709

---

Which Model uses the SET concept

745

---

Why do we use non clustered index?

734

---

What is left outer join in sql server joins?

694

---

Is sql server implemented as a service or an application? : Sql server database administration

700

---

---

Differentiate between sql temp table vs table variable?

667

---

How you can find out if an index is useful to the optimizer?

660

---

what exactly sql injuction.how to overcome.....

2243

---

What will be the maximum number of index per table?

715

---

What are some examples of schemas?

705

---

How can sql server instances be hidden?

690

---

What does dml stand for?

683

---

What is the function of sql server agent windows service?

749

---

Explain transaction server implicit?

688

---

Do you know what is similarity and difference between truncate and delete in sql?

760

---