What is difference between delete & truncate commands?

0 Answers  

---

can an order by clause be used in a creation of a view?

0 Answers  

---

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 Answers  

---

What is store procedure? How do they work?

0 Answers  

---

Is sql server implemented as a service or an application? : 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  

---

What is an index in sql?

0 Answers  

---

what is raid and what are different types of raid configurations? : Sql server database administration

0 Answers  

---

Explain different types of Normalization.

0 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

what is the use of database index(apart from the last searching of records) and what is the use of composite key?

1 Answers  

---

What is truncate table?

0 Answers  

---

Why truncate is ddl command?

0 Answers  

---