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
- 3324 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
In what sequence sql statement is processed?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
What is ems sql management studio? : sql server management studio
What is row_number function?
Why use sub query in sql server and list out types of sub queries?
What is instead of trigger sql server?
What are the different types of upgrades that can be performed in sql server?
What is right outer join in sql server joins?
Can you explain about buffer cash and log cache in sql server?
Explain what is “asynchronous” communication in sql server service broker?
What are partitioned views and distributed partitioned views?
What are 3 ways to get a count of the number of records in a table?
How do triggers work?
can an automatic recovery be initiated by a user? : Sql server administration
What is correlated subquery in sql server?
