Explain “@@rowcount” and “@@error” in sql server?

0 Answers  

---

What is the difference between referencing and joining?

1 Answers  

---

Describe how to use the linked server?

0 Answers  

---

Can a table have 2 foreign keys?

0 Answers  

---

Why is the need for data conversion transformations?

0 Answers  

---

What is the main purpose of having conversation group?

0 Answers  

---

Which data type columns are the best candidates for full-text indexing?

0 Answers  

---

Is it true, that there is no difference between a rule and a check constraint?

0 Answers  

---

how can ur insert the emp table

3 Answers   Wipro,

---

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

0 Answers  

---

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

---

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

0 Answers  

---