what is the difference between openrowset and openquery?

0 Answers  

---

Where are stored procedures in sql server?

1 Answers  

---

Explain the dbcc pintable command when would you use it?

1 Answers  

---

What is temporal data type?

1 Answers  

---

Can foreign key be deleted?

1 Answers  

---

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

1 Answers  

---

Do you know nested transaction?

1 Answers  

---

What type of locking occurs during the snapshot generation? : sql server replication

1 Answers  

---

What are ddl triggers and types of ddl trigger?

1 Answers  

---

What is difference between table aliases and column aliases? Do they affect performance?

1 Answers  

---

What is unique key constraint?

1 Answers  

---

Explain the disadvantages of cursors?

1 Answers  

---