Answer Posted / johnny

Magic? I'm still waiting for the rabbit to appear...

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1032

---

What is a view in sql?

1048

---

What are the different subsets of sql?

1662

---

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1083

---

How do I find the sql server version?

1114

---

How efficient you are in oracle and SQL server?

1269

---

What are the different types of subquery?

1240

---

How do I start sql server 2017?

1024

---

How to rebuild the master database?

1175

---

What is sql server query analyzer?

1137

---

Why and when do stored procedure recompile?

1077

---

what is the difference between openrowset and openquery?

1208

---

How to enter binary string literals in ms sql server?

1256

---

What is acid mean in sql server?

1257

---

How to remove duplicate rows from table except one?

1096

---