What are the new features in SQL Server 2005 when compared to SQL Server 2000?

0 Answers  

---

what are acid properties? : Sql server database administration

0 Answers  

---

What is database dimension? : sql server analysis services, ssas

0 Answers  

---

in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 Answers  

---

Explain about temporary stored procedure?

0 Answers  

---

how to rest identity columns in sql server

3 Answers   Matrix,

---

What is openrowset sql server?

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 a sub-query? When would you use one?

3 Answers  

---

Explain ranking functions?

0 Answers  

---

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

0 Answers  

---

How to check if stored procedure is running in sql server?

0 Answers  

---