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
- 3180 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
can a table be moved to different filegroup? : Sql server administration
What are the different editions available in sql server 2000?
What is the difference between stored procedure and user defined functions?
Why is the need for data conversion transformations?
Explain the stored procedure?
What is the difference between mysql and mysqli?
What are difference between Cluster index and Non-Cluster index?
What command do we use to rename a db, a table and a column?
What is a primary index?
How to execute the cursor queries with "open" statements?
What are the advantages of having an index on the sql server?
What do you mean by an execution plan?
What happens if null values are involved in boolean operations?
What is simple indexing method?
What is row_number()?
