What is the difference between count and distinct count?

0 Answers  

---

How can i change the column name.

13 Answers   HCL, Yardi Software,

---

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

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  

---

can we call stored Procedure in Function in Sql Server 2000 and vice versa.

3 Answers   C3I, eSoft, iPRO Solutions, Wipro,

---

CREATE a table from another table

2 Answers  

---

How do I create a stored procedure in sql server?

0 Answers  

---

What is sorting and what is the difference between sorting and clustered indexes?

1 Answers  

---

What is dbcc?

0 Answers  

---

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

0 Answers  

---

What is a with(nolock)?

0 Answers  

---

Creating Tables Using SELECT

1 Answers  

---