What happens if the update subquery returns multiple rows in ms sql server?

0 Answers  

---

Can a table have 2 primary keys?

0 Answers  

---

What are examples of triggers?

0 Answers  

---

What program is used to store the data source file?

0 Answers  

---

How can you hide the sql server instances?

0 Answers  

---

What are the commands used in DCL?

0 Answers  

---

How to find the date and time of last updated table?

6 Answers   Teledata,

---

Difference between report and query parameter.

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  

---

What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?

4 Answers   Wipro,

---

Tell me what is difference between view and materialized view?

0 Answers  

---

What is advantage data architect?

0 Answers  

---