Answer / Anup Kumar Srivastav

[{"clustered index": "A type of index that organizes the actual data in a specific order based on the indexed column. Only one table can have a single clustered index."}, {"non clustered index": "A type of index that stores the data rows in their original location and only creates an index to speed up search operations. A table can have multiple non-clustered indexes.

what types of replication are supported in sql server? : Sql server database administration

1 Answers  

---

Difference between writing SQL query and stored procedure ?

15 Answers   Cognizant, Infosys, TCS, Veritas,

---

What are different types of constraints?

0 Answers  

---

Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem

2 Answers  

---

Is null in sql server?

1 Answers  

---

New concepts of sql server 2005 use in your project.

1 Answers   TCS,

---

what is the disadvantage of SQL Loder?

1 Answers   TCS,

---

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  

---

we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz

6 Answers  

---

How you trouble shoot when any job fails

1 Answers  

---

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

1 Answers  

---

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1 Answers  

---