C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...
New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !




Trigger in different version of sqlserver


Posted Date: 11 Apr 2008    Resource Type: Articles    Category: Databases
Posted By: Nitin Srivastava       Member Level: Gold
Rating:     Points: 3



In SQLServer 6.5 :
We can define only three triggers per table
One for INSERT
One for UPDATE and
One for DELETE.


From SQL Server 7.0 onwards:
This restriction is gone and now we can create multiple triggers per each action.
Like we can create more than one trigger for INSERT etc..

But SQL Server 7.0 has one restriction
We can't specify which trigger fires first and which at last.

In SQL Server 2000
We can specify which trigger will fires first and which at last,
but still we cannot order the rest of trigger.



Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks      
Popular Tags   What are tags ?   Search Tags  
Trigger  .  

Post Feedback


This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.
Next Resource: Difference between ISNULL() and COALESCE().
Previous Resource: What is collation in SQLSERVER.
Return to Discussion Resource Index
Post New Resource
Category: Databases


Post resources and earn money! 		 
Related Resources


dotNet Slackers   BizTalk Adaptors    Web Design

internet fax

Contact Us    Privacy Policy    Terms Of Use