Answer Posted / jeetu

Function can be used inside the queries but Store procedure never used inside the queries For Example Given below:

select avg(salary) from employee;// allowed here

avg(): is function

Select sp(salary) from employee // Not allowed here

sp(): is stored Procedure

Thanks

What is difference between commit and rollback when used in transactions?

504

---

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

684

---

What is format parameter in ssrs?

109

---

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

506

---

Is sql different from sql server?

517

---

---

What is a transactions?

606

---

Define cursor locking

552

---

Which data type columns are the best candidates for full-text indexing?

604

---

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

559

---

Explain error and transaction handling in sql server?

506

---

What is optimization and its types?

539

---

What is the difference between upgrade and migration in sql server?

598

---

How to drop existing indexes in ms sql server?

593

---

What is isnull() operator?

572

---

How to disable triggers using "disable trigger"?

568

---