Answer Posted / vijay dev arya

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

Define cursor locking

550

---

Explain security with sql azure?

161

---

Explain syntax for viewing trigger?

539

---

Can select statements be used on views in ms sql server?

582

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

522

---

---

How to grant a permission in ms sql server using "grant execute" statements?

565

---

How do clustered indexes store data?

615

---

What are pessimistic lock and optimistic lock?

550

---

What is ssrs?

99

---

What are the differences between local and global temporary tables?

560

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

543

---

What are different types of views?

551

---

How to create an inline table-valued function?

540

---

Find first and last day of current month in sql server

597

---

How to write an inner join with the where clause in ms sql server?

557

---