Answer / pandian

There are two types of indexs.
1. Cluster Index (Ex. Primary Key)
2. Non Cluster Index(Ex.Unique Key)

Answer / bala

Filtered Index in case of SQL Server 2008

what is hash table

3 Answers   ILFS, Teledata,

---

What is 'write-ahead log' in sql server 2000 ?

0 Answers  

---

How to get @@error and @@rowcount at the same time?

0 Answers  

---

How m-m relationships are implemented?

2 Answers  

---

How to grant a permission in ms sql server using "grant execute" statements?

0 Answers  

---

---

what is database replicaion? : Sql server database administration

0 Answers  

---

What is the difference between primary key and unique constraints?

0 Answers  

---

Tell about MOM Tool(Microsoft Operator Manager)?

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 transaction and what are ACID properties?

14 Answers   Config Systems, IBM, TCS, Virtusa,

---

How will u test the stroded procedures and functions? difference between SP and Triggers

2 Answers   TCS,

---

What are the four main query statements?

7 Answers   Wipro,

---