what are the disadvantages of cursors? : Sql server database administration

0 Answers  

---

Define Check points and End Points?

1 Answers  

---

statement (of account) Receive ID_receive Date_receive Amount_receive TO_receive From_receive Description_receive 1 2010/01/01 500 Bank Ahmed Payment from the account 2 2010/02/01 700 Bank Ahmed Payment from the account Payment ID_payment Date_payment Amount_payment From_payment To_payment Description_payment 1 2010/03/01 1000 Ahmed Sales Sale goods 2 2010/04/01 1500 Ahmed Sales Sale goods How can crate Stored Procedures for the statement (of account) from these tables? I want statement (of account) like this: (in sql 2005) ID_ name description debit account credit account balance

1 Answers  

---

What is usually the first word in a sql query?

0 Answers  

---

How to rebuild master databse?

0 Answers  

---

What is Index ? Explain its Types?

2 Answers   ADP,

---

What is lock escalation?

1 Answers  

---

Which tcp/ip port does sql server run on? How can it be changed?

0 Answers  

---

What do you understand by SQL*Net?

0 Answers   Tech Mahindra,

---

What is the osql utility?

0 Answers  

---

What is a table called, if it does not have neither Cluster nor Non-cluster Index?

2 Answers  

---

How will you know when statistics on a table are obsolete?

0 Answers  

---