Answer Posted / arslan

the basic difference between in and exists

let's take the example of for loop in c++ and in loops when you write break statement it will iterates until the condition of break statement will true this like exist and in
if you didn't put break in it then it will execute the whole loop

What is the full form of dql?

1022

---

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

113

---

What are the types of processing and explain each? : sql server analysis services, ssas

1202

---

What is rs.exe utility?

162

---

Is a primary key unique?

1035

---

How to enter unicode character string literals in ms sql server?

1113

---

Do you know what is a with(nolock)?

1103

---

What is use of dbcc commands?

1121

---

What are different backups available in sql server?

1152

---

Explain what are partitioned views and distributed partitioned views?

1012

---

What are the encryption mechanisms in sql server?

1077

---

What is difference between after and before?

1186

---

Explain forward - only cursors?

1127

---

What is the difference between locking and multi-versioning?

1038

---

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

1067

---