optimization techinques

0 Answers   Wipro,

---

What are the database roles? : sql server security

0 Answers  

---

Why we use functions in sql server?

0 Answers  

---

What is the maximum number of index per table?

0 Answers  

---

what is the maximum size of a row? : Sql server database administration

0 Answers  

---

plz send every query in sql server2000

1 Answers   Infosys,

---

What is dynamic cursor in SQL SERVER?

0 Answers  

---

 Explain what is sql override for a source taLle in a mapping?

0 Answers   Informatica,

---

how would you improve etl (extract, transform, load) throughput?

0 Answers   LinkedIn,

---

Benefits of Stored Procedures?

0 Answers   Wipro,

---

How can you append an identity column to a temporary table?

0 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  

---