Can I know,how to Execute Funcion and Trigger through command(Manualy Executio

Can I know,how to Execute Funcion and Trigger through
command(Manualy Execution) in MS SQL/SERVER 2005,give me
answer with Example.

Question Posted / digvijay singh

1 Answers
3732 Views
I also Faced
E-Mail Answers

Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER ..

Answer / bhaskar

Function can excute by the SELECT statement
ex SELECT Functionname(parameters), select *from
functionname

select s_func(Parameters)

We cant execute the trigger ,
When we perform a DML(DELETE,INSERT,UPDATE) operation
Trigger will fire automatically

Is This Answer Correct ?

4 Yes

0 No

Post New Answer

More SQL Server Interview Questions

What is a View ? Can we insert, Update and delete a view?

0 Answers Arigo Infotech,

How cand Optimize SQL Server Stored Procedures

1 Answers

system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??

8 Answers

what are cursors? : Sql server database administration

0 Answers

What is INTVAL( )and where we use Plz any body help me

1 Answers

What is the difference between a stored procedure and a user defined function?

0 Answers

Why use triggers?

0 Answers

what is the Enterprise manager(2000) and management studio (2005)?

2 Answers

How do I edit a stored procedure in sql server?