Difeerence between ssis 2005 and ssis2008?

1 Answers   Convergys,

---

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  

---

What are the steps you will take to improve the performance of a poor performing query?

0 Answers  

---

Is SET a SQL Keyword?

4 Answers   BitWise,

---

Why do we use sql limitations? Which constraints can we use while making a database in sql?

0 Answers  

---

How to get the definition of a view out of the sql server?

0 Answers  

---

What is snapshot replication?

0 Answers  

---

What are cursors? Name four types of cursors and when each one would be applied?

3 Answers   Adea Solutions,

---

can you any body tell me suppose database is suspect mode. how can take to normal?

2 Answers   Teledata,

---

How do database indexes work?

0 Answers  

---

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---

What is triggers in ms sql server?

0 Answers  

---