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
- 3728 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
Can truncate be rolled back?
How to find the version of sql server? : sql server database administration
What is a non equi join?
How to list all schemas in a database?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
Can we add an identity column to decimal datatype?
What is 1nf 2nf?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
What it means to be triggered?
What are the key configuration files for sql server reporting services ?
What is the security principal at the database level that represents your session?
Why are you getting errors when creating a new odbc dsn?
what is bit datatype? : Sql server database administration
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
