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
- 3895 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 convert character strings into numeric values?
do you know how to configure db2 side of the application? : Sql server database administration
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
How to provide default values to function parameters?
List out the different types of locks available in sql server?
What is subquery? Explain the properties of a subquery?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is normalization and what are the advantages of it?
What is the difference between for xml raw and for xml auto?
What is acid mean in sql server?
What is a coalesce function?
How can you append an identity column to a temporary table?
Why use identity in sql server?
What are the different subsets of sql?
Where can you add custom error messages to sql server?
