Answer Posted / phani

we can use, but select columns and having columns should
use with aggregare functions

ex:
select max(empid), min(marks)
from employee
having max(empid_id)>100

What is a trace frag?

1035

---

Can you explain different types of joins?

884

---

Can you edit the .rdl code associated with a linked report?

149

---

Explain what are commit and rollback in sql?

864

---

What do you mean by 'normalization'?

1002

---

How many columns can exist together per table?

1101

---

What are the advantages of user-defined functions over stored procedures in sql server?

959

---

What is cross join in sql server joins?

1073

---

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

936

---

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

968

---

Can we use custom code in ssrs?

1056

---

How to define and use table alias names in ms sql server?

1041

---

How to join two tables in a single query in ms sql server?

941

---

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

996

---

What is ddl and dml commands?

848

---