Answer / Ravi Ranjan Dubey

Database roles are a collection of database users that have been grouped together for the purpose of granting or denying access to specific resources

How to create stored procedures with parameters in ms sql server?

1 Answers  

---

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

0 Answers  

---

How to defragment table indexes?

1 Answers  

---

how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

9 Answers   Deloitte, Lason,

---

What is tempdb database? : SQL Server Architecture

1 Answers  

---

How to find the version of sql server? : sql server database administration

1 Answers  

---

What is row by row processing ?

2 Answers  

---

Can we call stored procedure in trigger?

1 Answers  

---

What are different types of Keys? Please explain all the keys with a suitable example.

4 Answers  

---

Write a SQL queries on Self Join and Inner Join.

1 Answers   Aspiring Minds,

---

What is the use of set nocount on/off statement?

1 Answers  

---

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

1 Answers  

---