Can we return Data from 4(more than 1) tables in stored procedure?

0 Answers   HCL,

---

What does the on delete cascade option do?

0 Answers  

---

Why does sql studio use a single registered database repository? : sql server management studio

0 Answers  

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

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  

---

---

Explain use of expression builder.

0 Answers  

---

Where are magic tables stored ? Is it in the same database where it is created ?

4 Answers  

---

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product

2 Answers  

---

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

0 Answers   Microsoft,

---

How many levels of sp nesting are possible?

0 Answers  

---

Find top Nth employee from each department in terms of salary?

13 Answers   RealPage,

---

what exactly sql injuction.how to overcome.....

0 Answers   CTS, IBM,

---