What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

0 Answers  

---

How do I edit a procedure in sql server?

0 Answers  

---

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

0 Answers   IBM,

---

Explain indexed views and partitioned view with their syntax.

0 Answers  

---

Benefits of Stored Procedures?

0 Answers   Wipro,

---

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

0 Answers  

---

Explain having clause and where clause?

0 Answers  

---

What is de-normalization and what are some of the examples of it?

0 Answers  

---

Can you index views?

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,

---

Explain what is the difference between union and union all?

0 Answers  

---

what is hash nonclustered index

0 Answers  

---