AsifCh Posted December 23, 2003 Posted December 23, 2003 Can any body help me to write triggers in the SQL Server 2000. Tell me about some good articals Thanks Quote Asif Raza Ashraf Senior Software Engineer Electronic Solutions Pakistan Islamabad
*Experts* Nerseus Posted December 23, 2003 *Experts* Posted December 23, 2003 Do you know SQL syntax? That's mostly all a trigger is. Have you written stored procedures? Again, very similar. The biggest difference is in using the built-in tables updated, deleted, inserted which are similar to "this" (C#) or "Me" (VB.NET) in that they represent whatever table the trigger is for. SQL Server comes with a link to Books Online. I'd look in there as it has a ton of info on triggers, including sample code for common tasks and more. -Nerseus Quote "I want to stand as close to the edge as I can without going over. Out on the edge you see all the kinds of things you can't see from the center." - Kurt Vonnegut
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.