1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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


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

How many cores do I need for sql server 2016?

0 Answers  

What is the default isolation level of the sql server database?

1 Answers   Ness Technologies,

What are indexes in ms sql server?

0 Answers  

How are the unique and primary key constraints different?

0 Answers  

Can a trigger be created on a view?

0 Answers  




What is sql server profiler trace data file?

0 Answers  

What is the basic functions for master, msdb, tempdb databases?

2 Answers   CSC,

How to remove duplicate rows from table?

0 Answers  

What are triggers? How do you invoke a trigger on demand?

0 Answers   Hexaware,

What options are available to audit login activity? : sql server security

0 Answers  

What is normalization of database? What are its benefits?

0 Answers  

What is the use of stored procedure?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories