Does group by sort data?

0 Answers  

---

Explain the concept of view and Types of views in SQL server?

0 Answers   HCL,

---

What are the steps to process a single select statement?

0 Answers  

---

How many types of local tables are there in sql server?

0 Answers  

---

Determine when an index is appropriate?

0 Answers  

---

---

Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

3 Answers   247Customer,

---

Define self join in sql server joins?

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 are the underflow and overflow behaviors on float literals?

0 Answers  

---

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

0 Answers  

---

What is nonclustered index with included columns ?

0 Answers  

---

What is bit data type?

0 Answers  

---