Interested to Buy Any Domain ? << Click Here >> for more details...
Can I know,how to Execute Funcion and Trigger through
command(Manualy Execution) in MS SQL/SERVER 2005,give me
answer with Example.
- 1 Answers
- 3759 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
What is postgresql server?
What is self contained multi valued query?
when you create a database how is it stored? : Sql server database administration
Is it possible to update the views? If yes, how, if not, why?
Explain what are commit and rollback in sql?
How to retrieve error messages using odbc_errormsg()?
Is the log file is a part of file group?
Can I save my report as html, excel or word? : sql server management studio
Who developed sql server?
What are recommended options to be used while using db mirroring? : sql server database administration
Which is faster statement or preparedstatement?
Explain syntax for viewing, dropping and disabling triggers?
Where views are stored in sql server?
What is normalization? Explain its different types?
