Answer Posted / dinesh rathod

Self join is just like any other join, except that two instances of the same table will be joined in the query

How do you delete duplicate rows in sql server?

899

---

What is the difference between a local and a global temporary table?

1055

---

How to create a simple user defined function in ms sql server?

969

---

What is log in sql server?

1076

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

900

---

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8109

---

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1066

---

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

115

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

850

---

What does it mean to manipulate data?

942

---

What is scd (slowly changing dimension)? : sql server analysis services, ssas

952

---

What is difference between standardization and normalization?

1019

---

Do you know concepts and capabilities of sql server?

1006

---

How to get the definition of a user defined function back?

1000

---

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

1988

---