Answer Posted / hiral bhatt

Dear All,

Cursor, its an object in SQL Server and the main advantages
of cursor is that whenevr we need to fetch records in row
by row Manner..

But using cursor, it itself is not a good concept, we have
another alternate for cursor like Temp Table.

Regards
Hiral Bhatt
Sr. Software Engg.

Tell me what is log shipping?

977

---

Explain relational data?

929

---

What is Sqlpaging in SqlServer 2005 ?

1072

---

Explain the properties of sub-query in sql server?

1018

---

What are the different types of replication are there in sql server 2000?

1043

---

What is query parameter in ssrs?

162

---

What is exporting and importing utility?

1091

---

Is natural join and equi join same?

975

---

What information is maintained within the msdb database?

984

---

What is a transaction and why is it important?

1091

---

How many columns can exist together per table?

1156

---

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

2028

---

What is the template in sql?

981

---

What is merge replication?

1109

---

How do I create a stored procedure in dbml?

1011

---