Answer Posted / vardharaj

SELECT TOP 1 ID FROM TABLENAME WHERE ID NOT IN (SELECT TOP 1
ID FROM TEST)

What is transaction server auto commit?

984

---

How to check status of stored procedure in sql server?

912

---

How sql server enhances scalability of the database system?

1111

---

What are the steps you can take to avoid “deadlocks”?

919

---

What is ms sql server index?

1024

---

What happens if null values are involved in datetime operations?

903

---

What are window functions in sql server?

937

---

Define union, union all, minus, intersect?

933

---

How to declare and use cursor variables?

1074

---

Is it possible to create trigger on views?

935

---

Write a program using SQL queries to find a unique entry in a table.

941

---

What do you mean by an execution plan?

1052

---

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

2180

---

Explain different types of index?

985

---

How to execute the cursor queries with "open" statements?

1096

---