What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

0 Answers  

---

How can we solve concurrency problems?

0 Answers  

---

Where do we generally create INDEX?

1 Answers   Ernst Young, Thomson Reuters,

---

what is bit data type? and what are the information that can be stored inside a bit column?

2 Answers  

---

‘Order by’ is not allowed in a view how can you sort information from a view?

0 Answers  

---

---

How many index keys possible for a table

6 Answers  

---

What is the difference between insensitive and scroll cursor?

0 Answers  

---

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

0 Answers   Satyam,

---

Can you force a query to use a specific index?

0 Answers  

---

What is the difference between primary key and unique constraints?

0 Answers  

---

How many databases Microsoft SQL server provides?

0 Answers   Abacus,

---

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?

5 Answers  

---