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
- 3839 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 candidate key, alternate key, and composite key?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
What is the difference between Clustered and Non-Clustered Index?
Why people hate cursor?
Explain data warehousing in sql server?
How to rebuild the master database?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
what is hash nonclustered index
Explain what is the difference between a local and a global temporary table?
How to list all tables in the database using odbc_tables()?
Which is faster statement or preparedstatement?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
Do you have any idea about the tcl commands?
