How do I start sql server 2016?

0 Answers  

---

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

0 Answers  

---

Can you please differentiate between a primary key and a unique key?

0 Answers  

---

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 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 set nocount on and what is set nocount off?

0 Answers  

---

What is the exact numeric data type in sql?

0 Answers  

---

Explain collation?

0 Answers  

---

Does partitioning improve performance?

0 Answers  

---

List out the differences between global and local temp tables in sql server?

0 Answers  

---

Explain cursor as data base object?

0 Answers  

---

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

0 Answers  

---