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

What are the different types of join?

0 Answers  

Describe in brief databases and sql server databases architecture.

0 Answers  

Define indexes?

0 Answers  

Write an sql query for deleting duplicate rows?

0 Answers  

What is use of except clause?

0 Answers  




How to execute function in stored procedure sql server?

0 Answers  

Do you know how to make remote connection in database?

0 Answers  

find the 3rd max salary

10 Answers  

Explain what are db_options used for?

1 Answers   InterGraph,

How do I run a trace in sql server?

0 Answers  

How do I find the transaction log size in sql server?

0 Answers  

What is user defined datatypes and when you should go for them?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories