Advanced Search

Return to Snippet

Revision: 3528
at August 7, 2007 19:04 by rengber
Initial Code 
CREATE TRIGGER [RobTestTrigger] ON [dbo].[RobTestTable] 
  FOR UPDATE 
  AS
    UPDATE t
      SET t.Version = t.Version + 1
      FROM RobTestTable t
      JOIN inserted i on i.Id = t.ID
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Update Trigger to Increment a Version Number Column

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
database

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL