What are the differences between substr and charindex in sql server.

0 Answers  

---

Define union, union all, minus, intersect?

0 Answers  

---

What is a performance monitor?

0 Answers  

---

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers   HCL, Wipro,

---

How do you find the error, how can you know the number of rows effected by last SQL statement?

2 Answers  

---

Do you know the isolation level that sql server support?

0 Answers  

---

How to test odbc dsn connection settings?

0 Answers  

---

Difference between Triggers and Stored Procedure

23 Answers   Claimat, HCL, Protech, Silgate,

---

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,

---

What is a bit datatype?

0 Answers  

---

What is the fastest way to permanently delete a 1 million row table named customers?

0 Answers  

---

How to use values from other tables in update statements in ms sql server?

0 Answers  

---