What is difference between cte and view?

0 Answers  

---

1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers  

---

What is a rollup clause?

0 Answers  

---

Explain relational data?

0 Answers  

---

What is a result set object returned by odbc_exec()?

0 Answers  

---

What do you mean by collation recursive stored procedure?

0 Answers  

---

hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?

7 Answers   Google, TCS, Unisys,

---

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  

---

How to drop an existing schema in ms sql server?

0 Answers  

---

What is purpose of normalization?

0 Answers  

---

What is the difference between DataRow.Delete() and DataRow.Remove()?

0 Answers  

---

What is the difference between for xml raw and for xml auto?

0 Answers  

---