Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / m.ramarathna
Triggers are special kind of stored procedure that get
executed automatically when insert,update,delete operation
takes place on a table. Trigger can't be invoked on demand.
when delete,update,insert one data in the table ,that data
will stored in another one table.Nobody can't open the table
.That can open only by the select user.because of trigger
we give full importants to all data .
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
How to define the name and server for a new dsn?
What is a collation?
what are the reporting service components in SSRS?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
What are dml (data manipulation language) statements in ms sql server?
What is the difference between local and global temporary tables?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
Can another user execute your local temporary stored procedures?
How do you trace the traffic hitting a sql server?
Can a table be created inside a trigger?
What is field in algebra?
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.
How to apply filtering criteria at group level with the having clause in ms sql server?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
