Answer Posted / poornima k

create table &t_name(&f_name1 &datatype1);

Explain the concept of view and Types of views in SQL server?

623

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

557

---

How to create new tables with "create table" statements in ms sql server?

571

---

How to find the second highest salary of an employee?

599

---

Do you know the policy based administration feature of sql server 2008?

582

---

---

Why is sql server log file full?

543

---

What is statement level trigger?

547

---

What are clustered and non-clustered index?

554

---

What are the components of dbms?

535

---

What is the chart in report?

111

---

Explain datetimeoffset data type in sal server 2008?

546

---

What is the difference between push and pull subscription? : sql server replication

624

---

How to select some specific columns from a table in a query in ms sql server?

507

---

What is the openxml statement in sql server?

541

---

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

554

---