like as storeprocedure it is userdefind function ther is no parameters

WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?

Question Posted / kavithareddy

Answer Posted / kavithareddy

like as storeprocedure
it is userdefind function ther is no parameters

1)After trigger:

2)Insted of trriger

Is This Answer Correct ?

2 Yes

17 No

Please Help Members By Posting Answers For Below Questions

What is the usage of sign function?

1081

How to start sql server browser service?

1117

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

968

How do I partition a table in sql server?

1020

Which joins are sql server default?

979

What are a scheduled jobs?

943

Explain user defined views?

945

Can you explain what is indexed view? How to create it?

886

How to execute a stored procedure in ms sql server?

1136

how would you improve etl (extract, transform, load) throughput?

1009

How many types of subqueries are there in sql server?

972

What is faster join or union?

1180

Does group by sort data?

883

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

927

What is instead of dml trigger?

977