Answer Posted / latha.s

select distinct * from tablename;

explain different types of joins? : Sql server database administration

920

---

how you can move data or databases between servers and databases in sql server? : Sql server administration

914

---

What do you understand by a view? What does the with check option clause for a view do?

951

---

 Explain what is sql override for a source taLle in a mapping?

944

---

Define views.

960

---

How to change a login name in ms sql server?

1023

---

Define master database?

988

---

What is difference between rownum and rowid?

855

---

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

958

---

Explain aggregate functions?

1026

---

What is mean by dml?

945

---

What is sql server management studio? : sql server management studio

1012

---

What is cte (common table expression)?

976

---

What are the types of database schema? : sql server analysis services, ssas

1067

---

What are the Advantages of using CTE in sql server?

1040

---