Difference between Function and Procedure-in general?

6 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 minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

0 Answers  

---

What are Spatial data types in SQL Server 2008

0 Answers   Infosys,

---

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 Answers   Cognizant,

---

---

What are the restraints imposed on the table design by a merge replication?

0 Answers  

---

What is a filestream?

0 Answers  

---

What are cursors in ms sql server?

0 Answers  

---

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

0 Answers  

---

how to trace the traffic hitting a sql server? : Sql server database administration

0 Answers  

---

How many tables can be joined in SQL Server?

0 Answers   Cap Gemini,

---

What are the system database in sql server 2005?

0 Answers  

---