Answer Posted / divya mahendra sikarwar

SELECT FormID,
FormCode,
LangCode,
count(*)

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

Explain the difference between cross join and full outer join?

1029

---

Tell me what is the stuff and how does it differ from the replace function?

1034

---

Define clusters?

1139

---

How to perform backup for certificates in sql server? : sql server security

1141

---

How do you troubleshoot errors in a SQL Server Agent Job?

1104

---

How to loop through the result set with @@fetch_status?

1429

---

what is hash nonclustered index

1019

---

How to configure odbc dsn with different port numbers?

1151

---

What is snapshot replication?

1096

---

How many types of subqueries are there in sql server?

1031

---

Explain what role entity and relationship play in an ER diagram.

1111

---

Why use “nolock” in sql server?

1133

---

What is scrollable cursor?

1080

---

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1036

---

Can I work with several databases simultaneously? : sql server management studio

1029

---