a l t e r   p r o c   A d d M e n u   @ I D   i n t ,   @ P l a c e _ I D   i n t ,   @ T i t l e   n v a r c h a r ( 2 0 0 ) , @ D l l N a m e   n v a r c h a r ( 1 0 0 ) , @ F o r m P a t h   n v a r c h a r ( 2 0 0 ) , @ P a r a m e t e r   n v a r c h a r ( 2 0 0 ) ,       
 
   @ P r i o r i t y   i n t ,   @ I c o n N a m e   n v a r c h a r ( 4 0 0 ) ,   @ M a x F o r m C o u n t   i n t ,   @ D o m _ I D _ M e d i a   i n t ,   @ I c o n F o n t   n v a r c h a r ( 2 0 0 ) ,   @ I c o n C o l o r   n v a r c h a r ( 2 0 0 ) ,       
 
   @ U r l   n v a r c h a r ( 2 0 0 0 ) ,   @ D o m _ I D _ R o w T y p e   i n t     ,   @ i s A c t i v e 	 i n t 
 
 a s                 
 
 b e g i n                 
 
   i f   n o t   e x i s t s ( s e l e c t   i d   f r o m   P l a c e s   w h e r e   I D   =   @ I D )     
 
   b e g i n     
 
     i n s e r t   i n t o   P l a c e s   ( I D , P l a c e _ I D , T i t l e , D l l N a m e , F o r m P a t h , P a r a m e t e r , P r i r i t y , I c o n N a m e , M a x F o r m C o u n t , D o m _ I D _ M e d i a , I c o n F o n t , I c o n C o l o r , U r l , D o m _ I D _ R o w T y p e , I s A c t i v e )     
 
     v a l u e s   ( @ I D , @ P l a c e _ I D , @ T i t l e , @ D l l N a m e , @ F o r m P a t h , @ P a r a m e t e r , @ P r i o r i t y , @ I c o n N a m e , @ M a x F o r m C o u n t , @ D o m _ I D _ M e d i a , @ I c o n F o n t , @ I c o n C o l o r , @ U r l , @ D o m _ I D _ R o w T y p e , @ i s A c t i v e )     
 
   e n d     
 
   e l s e     
 
   b e g i n     
 
     u p d a t e   P l a c e s   s e t     
 
       P l a c e _ I D   =   @ P l a c e _ I D ,     
 
       T i t l e = @ T i t l e ,     
 
       D l l N a m e = @ D l l N a m e ,     
 
       F o r m P a t h   = @ F o r m P a t h ,     
 
       P a r a m e t e r =   @ P a r a m e t e r ,     
 
       P r i r i t y = @ P r i o r i t y ,     
 
       I c o n N a m e = @ I c o n N a m e ,     
 
       M a x F o r m C o u n t = @ M a x F o r m C o u n t ,     
 
       D o m _ I D _ M e d i a =   @ D o m _ I D _ M e d i a ,     
 
       I c o n F o n t = @ I c o n F o n t ,     
 
       I c o n C o l o r = @ I c o n C o l o r ,     
 
       U r l = @ U r l ,     
 
       D o m _ I D _ R o w T y p e   =   @ D o m _ I D _ R o w T y p e , 
 
       I s A c t i v e   =   @ i s A c t i v e 
 
     w h e r e   I D   =   @ I D     
 
   e n d     
 
 e n d       