Can you explain what are commit and rollback in sql?

0 Answers  

---

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

---

What is the ‘fillfactor’?

0 Answers  

---

how to find out the repeated value from table using groupby function?

4 Answers  

---

Explain the concepts and capabilities of sql server?

0 Answers  

---

Explain the dirty pages?

0 Answers  

---

Where are SQL server users names and passwords are stored in sql server?

0 Answers   HCL,

---

What will you do If the low Performance occurs?

2 Answers  

---

Explain how does the report manager work in ssrs?

0 Answers  

---

Define Foreign Key?

3 Answers   ADP, College School Exams Tests,

---

What are the purposes of floor and sign functions?

0 Answers  

---

i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L

8 Answers  

---