Answer Posted / divya mahendra sikarwar

SELECT FormID,
FormCode,
LangCode,
count(*)

FROM adzForm
GROUP BY FormID,
FormCode,
LangCode
HAVING COUNT(*)>1

What are the different types of Indexes available in SQL Server?

944

---

How do I setup a sql server database?

996

---

What is replication with database mirroring? : sql server database administration

982

---

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?

960

---

How to create new tables with "create table" statements in ms sql server?

995

---

How to replace null values in expressions using isnull()?

1047

---

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

181

---

How to create median function?

150

---

What is the openxml statement in sql server?

1006

---

What are tables in sql server?

960

---

What are number line correlation administrators will use while working with a subquery?

1095

---

Can you explain about buffer cash and log cache in sql server?

904

---

Explain the disadvantages of cursors?

1048

---

How can a database be repaired?

918

---

role of sql sever 2005 in database rather than any other database

1884

---