What is left outer join in sql server joins?

0 Answers  

---

How dts is used to extract, transform and consolidate data?

0 Answers  

---

What is spid in sql server profiler?

0 Answers  

---

Do you know sql server 2008 introduces automatic auditing?

0 Answers  

---

how to find the second salary?

10 Answers   HCL, Prithvi,

---

---

Write a SQL query to make a column as unique?

0 Answers   Cap Gemini,

---

Explain SELF JOIN ?

3 Answers   ADP,

---

What is the most common trace flags used with sql server?

0 Answers  

---

What is scheduled job and how to create it?

0 Answers  

---

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

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  

---

What is raid? : SQL Server Architecture

0 Answers  

---