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
- 3760 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 log ldf?
What is RMS migrations?
What is a database table?
if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?
what's sql server? : Sql server database administration
Do you know what is similarity and difference between truncate and delete in sql?
What happens if null values are involved in string operations?
Can we insert data if clustered index is disabled?
How to update values in a table with update statements in ms sql server?
what is syntex second or third highest salary. thanks & Regards Dhirendra sinha
What is the full meaning of dml?
Why people hate cursor?
-
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)
