What is the use of SCOPE_IDENTITY() function?

2 Answers  

---

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

0 Answers   Verizon,

---

How to create a scrollable cursor with the scroll option?

0 Answers  

---

How to encrypt data between dialogs?

0 Answers  

---

What are partitioned views?

0 Answers  

---

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

What is the use of =,==,=== operators?

0 Answers  

---

What are data resources?

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,

---

Explain DBCC?

0 Answers   QuestPond,

---

Explain go command in sql server?

0 Answers  

---

What happens if date-only values are provided as date and time literals?

0 Answers  

---