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
- 3652 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
What are the differences between substr and charindex in sql server.
How to set a database state to offline in ms sql server?
Where sql server user names and passwords are stored in sql server? : sql server database administration
how many type of indexing in database?
What is the rdl file?
Explain how you can configure a running aggregate in SSRS?
How to stop log file growing too big?
Explain about sql server login?
What is the difference between a view and a stored procedure?
What is Sqlpaging in SqlServer 2005 ?
How is table type constraint applied to a table?
How to Insert multiple rows with a single insert statement?
What is clustered vs nonclustered index?
What is 3nf normalization form?
What is partition, how will you implement it? : sql server analysis services, ssas
