While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

0 Answers  

---

How to insert and update data into a table with "insert" and "update" statements?

0 Answers  

---

What is ms sql server index?

0 Answers  

---

What are “unrepeatable reads”?

0 Answers  

---

What is table valued function and scalar valued functions?

0 Answers  

---

how you can list all the tables in a database?

0 Answers  

---

Explain about link server in sql server?

0 Answers  

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

If we shrink the Databse and Files, how much size is decreased?

1 Answers   TCS,

---

what is the basic diffrence betn a col declared in char(1) and in varchar(1)

2 Answers  

---

How to use order by with union operators in ms sql server?

0 Answers  

---

How to use subqueries in the from clause in ms sql server?

0 Answers  

---