Answer Posted / vijay dev arya

select salary from employee where salary>(select max
(salary) from employee)

How column data types are determined in a view?

968

---

What are the purposes and advantages stored procedure?

962

---

What is transact-sql language?

1103

---

Is natural join and equi join same?

981

---

What is a cache in ssrs?

138

---

How can you start sql server in different modes?

981

---

Difference between group by clause and having clause in SQL?

981

---

What is isolation levels?

1038

---

What are different type of Collation Sensitivity?

1011

---

Explain Capacity planning to create a database? and how to monitor it?

4208

---

Do you know what is a with(nolock)?

1067

---

Write query to return all rows sql?

1067

---

How can sql server instances be hidden? : sql server security

1159

---

Can two tables share the same primary key?

940

---

Does a sql server 2005 select statement require a from?

1025

---