insert into tblTickets( TicketID, UserID, GeneralCategory, SpecificCategory, UpdateDate )
values( '9', 'James Bond', 'Printing', 'Paper Issues', '1999-01-23' );


--- deleted ---
TicketID                             UserID                                   UpdateDate
------------------------------------ ---------------------------------------- --------------------------- 

--- inserted ---
TicketID                             UserID                                   UpdateDate                  
------------------------------------ ---------------------------------------- --------------------------- 
9                                    James Bond                               2002-04-11 16:53:00








update tblTickets
set UserID = 'M'
where TicketID = '9'


--- deleted ---
TicketID                             UserID                                   UpdateDate                  
------------------------------------ ---------------------------------------- --------------------------- 
9                                    James Bond                               2002-04-11 16:53:00

(1 row(s) affected)

--- inserted ---
TicketID                             UserID                                   UpdateDate                  
------------------------------------ ---------------------------------------- --------------------------- 
9                                    M                                        2002-04-11 16:53:07