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
- 3838 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 |
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
How to define the name and server for a new dsn?
How to delete all rows with truncate table statement in ms sql server?
What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?
How to create view in stored procedure sql server?
What are the dmvs?
How can you set the threshold at which sql server will generate keysets asynchronously?
What are sql servers used for?
Explain basic SQL queries with SELECT from where Order By, Group By-Having?
Hi, I have a table A which has four rows as follows Table A ------- empname salary ------- ------ A 1000 B 2000 C 3000 A 1000 B 2000 D 5000 I need the following output: empname salary ------- ------ A 1000 A 1000 B 2000 B 2000 Thanks in advance
what is the maximum size of a row? : Sql server database administration
What is model database? : SQL Server Architecture
-
Oracle (3253) - 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)
