Answer / kinthada cnu

hi all

Trigger nothing but special kind of stored procedure
it's providing security to table data.And it is automatically
fire when the queary excuted.

ex:
create trigger <trigger name>
on <table name>
for <insert/update/delete>
as
begin
<statments>
end

What are the disadvantages of using the stored procedures?

0 Answers  

---

How to call a function from a stored procedure in SQL Server ?

0 Answers   HCL,

---

How to find Duplicate Records In table?

0 Answers   HCL,

---

Write a SQL query to delete a table?

0 Answers   Amdocs,

---

I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?

1 Answers  

---

What are the different types of backups that exist?

0 Answers   ADITI,

---

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  

---

The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

0 Answers  

---

What is sql or structured query language?

0 Answers  

---

Tell about MOM Tool(Microsoft Operator Manager)?

0 Answers  

---

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

0 Answers  

---

What is scrollable cursor?

0 Answers  

---