Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3751 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
Define compound operators?
What is the difference between coalesce() & isnull()?
What are the advantages of using stored procedures?
What are the properties of sub-query?
What is the rdl file?
How to create a ddl trigger using "create trigger" statements?
How do you check sql server is up and running?
What is checkpoint process in the sql server?
What is difference between inner join and full join?
What is dml command?
How to get a list all databases on the sql server?
Explain full-text indexing?
Explain having clause and where clause?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
How to concatenate two strings in SQL Server.
