What is the difference between char, varchar and nvarchar?

0 Answers  

---

What is difference between delete & truncate commands?

0 Answers  

---

How do you find value of first column before inserting value into the second column in the same table for checking that second column must have different value than first column.

2 Answers   L&T,

---

What is the difference between NOROW and LOCKROW?

0 Answers   Accenture, Honeywell, Satyam,

---

What is the difference between join and inner join?

0 Answers  

---

---

Can you move the resources after pausing the node? : sql server database administration

0 Answers  

---

What is a schema in ms sql server 2005?

0 Answers  

---

Explain optimistic and pessimistic concurrency?

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  

---

How to loop through returning rows?

0 Answers  

---

What is meant by indexing?

0 Answers  

---

What are defaults? Is there a column to which a default can't be bound?

2 Answers   TCS,

---