Answer / Sanjeev Suman

A stored procedure is a prepared SQL code that can be called and reused as needed, and it returns no result set. A function, on the other hand, is a prepared SQL code that returns a single value or a table (in SQL Server) and can also be used within SELECT statements. In PL/SQL, functions must return a value but can have side effects through their implementation.

Explain about Views?

1 Answers   Infosys,

---

What do you mean by a dependent functionality in a build?

1 Answers   HCL,

---

How to delete the duplicate rows from a table in SQL Server ??

3 Answers  

---

Explain sql server service broker?

1 Answers  

---

What is the purpose of sql profiler in sql server? : sql server database administration

1 Answers  

---

How to connect ms access to sql servers through odbc?

1 Answers  

---

what r steps to we need to fallow b4 kill the process?

1 Answers   Verizon,

---

What is optimization and its types?

1 Answers  

---

How to drop an existing schema in ms sql server?

1 Answers  

---

What is autocommit mode in sql server?

1 Answers  

---

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1 Answers  

---

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 Answers  

---