Answer Posted / ramesh

stored procedure:

Group of sql statements compiled into single execution plan.

create procedure sp_procedurename
as
begin
begin transaction
select * from table

if @@error=null
commit

else
rollback

end

Trigger
--------

Trigger is a set of sql queries which fire when an event
occurs(delete,update,insert).

in 2005 DDL TRIGGER INTRUDUCED.

What is join query?

872

---

What are the main sources of data?

1076

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

890

---

Explain full-text indexing?

963

---

When to use null data driven subscription?

204

---

Write a SQL query to delete a table?

1118

---

How can you manage sql azure security?

101

---

write an SQL query to list the employees who joined in the month of January?

1664

---

What is a trigger and types of a trigger?

969

---

Difference between uniqe index and uniqe constraint?

950

---

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1015

---

Tell me about pre-defined functions of sql?

1096

---

What is the primary use of the model database?

1067

---

What are sql azure firewall rules?

106

---

How many full-text indexes can a table have?

961

---