Answer Posted / divya mahendra sikarwar

SELECT FormID,
FormCode,
LangCode,
count(*)

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

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

985

---

Do you know what is a linked server in sql server?

1024

---

What is DCL?

1052

---

What is a transact-sql statement batch in ms sql server?

1016

---

What is index in an assignment?

954

---

How to delete a login name in ms sql server?

1075

---

How to list all dsn entries on your local machine using odbc_data_source()?

1039

---

Explain different backup plans?

942

---

What does it mean to be in union?

934

---

Does group by sort data?

898

---

Is truncate autocommit?

938

---

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

993

---

How can you check the version of sql server?

1095

---

Explain what are the restrictions that views have to follow? : SQL Server Architecture

1048

---

Define self join?

1028

---