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
- 3037 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
Explain transaction server isolation?
What are sql dirty pages?
How to backup encryption key ?
What are the new scripting capabilities of ssms? : sql server management studio
What is a not null constraint?
How can we call UDF(User Define Function) using C# code in ASP.net ?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
What is a partition function in sql server?
Differentiate sql server reporting services vs. Crystal reports?
How do I start sql server 2017?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
What is SubQuery in SQL Server 2008
What is collation sensitivity? Explain different types.
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
Is port 1433 secure?
