Describe in brief system database.

0 Answers  

---

How do you use a subquery to find records that exist in one table and do not exist in another?

0 Answers  

---

Do you know what are various aggregate functions that are available?

0 Answers  

---

Difference between aggregate functions of sql?

0 Answers   EXL,

---

What are the security related catalog views? : sql server security

0 Answers  

---

in how many ways we can use count()

2 Answers  

---

What are the different types of cursor?

0 Answers   HCL,

---

Explain about thread and memory management process of SQL?

0 Answers  

---

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

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  

---

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

0 Answers  

---

What is field with example?

0 Answers  

---