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
- 3768 Views
- I also Faced
- E-Mail Answers
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 |
What is the difference between createstatement and preparedstatement?
Do you know how to store and query spatial data?
What are the database roles? : sql server security
What are the types of resultset?
How do triggers work?
how to get the salary in descending order with out using the keyword desc in sql
What is difference between commit and rollback when used in transactions?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
Do you know what is difference between stored procedure and user defined function?
What is index, cluster index and nonclustered index?
What is a db view?
What is blocking and how would you troubleshoot it? : sql server database administration
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
