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
- 3019 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
How to add an address record into adventureworkslt?
Describe the functionalities that views support.
What is bit data type?
What are a scheduled jobs or what is a scheduled tasks?
Do you know the cursor types?
What is the Control Flow in SSIS
How to optimize stored procedure optimization?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
What are security principals used in sql server 2005?
Write SQL queries on Self Join and Inner Join.
How to insert stored procedure result into temporary table?
How will you add a dimension to cube? : sql server analysis services, ssas
What is the minimum recommended amount of ram for sql server 2012 enterprise?
What is pivot and unpivot?
How to turn on the mssql api module in php?
