Difference between Triggers and Stored Procedure
Answers were Sorted based on User's Feedback
Answer / rajani kant
stored procedure
Definition
please give me Answer
| Is This Answer Correct ? | 34 Yes | 36 No |
Answer / amar
triggers is a block of code where is fired to do something action for insertion or delation of varioue t- sql statement........ where triggers are automatically fired.........
stored procedure is a predefined data types which is stored in a database............ stored procedure has to fire...........
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / love is my pation
i am saying to this web case if they understand what is the
differences between start and triggered. and if you know
please tell me.
Daaaaaaaaaaaaaaaaaaaaa!!!!!!!!!!1
| Is This Answer Correct ? | 1 Yes | 4 No |
How to Check if table exists in sql server?
What happens to a statement batch if there is a compilation error?
Can you insert NULL in unique column?
What is store procedure? How do they work?
What is the maximum size per database for sql server express?
Explain what are the database objects? : SQL Server Architecture
How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.
What happens to a trigger with multiple affected rows?
Is t sql the same as sql server?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
Explain what is row_number function?
What is ms sql server reporting services?
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)