what is the different types of backups available in sql server? : Sql server database administration

0 Answers  

---

what is sql injection?

2 Answers  

---

When to use Inner join & when to use subquery?

0 Answers   IBM,

---

How to join two tables in a single query in ms sql server?

0 Answers  

---

Mention a few common trace flags used with sql server?

0 Answers  

---

What command do we use to rename a db?

5 Answers   IBM,

---

What are null values in ms sql server?

0 Answers  

---

What is transact-sql ddl trigger?

0 Answers  

---

How to change the system date and time from SQL Plus Terminal ?

0 Answers   MCN Solutions,

---

What is difference between stored procedure and user defined function?

0 Answers  

---

What are the advantages of using stored procedures in sql server?

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  

---