"{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fprq1\fcharset0 Courier New;}{\f1\fnil\fcharset0 Arial;}}
{\colortbl ;\red0\green0\blue255;\red0\green0\blue0;\red255\green0\blue0;}
\viewkind4\uc1\pard\cf1\lang1024\f0\fs20 C\cf2 REATE\tab PROCEDURE pUpdateUsers
\par (
\par \tab\cf1 [(@p_\cf3 $Field!\cf1 |1|n)( \cf3 $DT!\cf1 |1|n)(,|1|n-1)]\cf2 
\par )
\par 
\par AS 
\par 
\par Begin
\par \tab Update \cf3 $Table!\cf2  set
\par \tab\cf1 [(\cf3 $Field!\cf1 =@p_\cf3 $Field!\cf1 |1|n)(,|1|n-1)]\cf2 
\par 
\par \tab return 
\par 
\par End\cf0\lang1033\f1\fs17 
\par }
_$$$_001_$$$_{\rtf1\ansi\ansicpg1252\deff0{\fonttbl{\f0\fnil\fcharset0 Verdana;}}
{\colortbl ;\red0\green0\blue0;\red255\green0\blue0;}
\viewkind4\uc1\pard\lang1033\f0\fs17 C\cf1 REATE\tab PROCEDURE pUpdateUsers
\par (
\par \tab @p_\cf2 UserID\cf1  \cf2 int\cf1 ,
\par @p_\cf2 Name\cf1  \cf2 varchar(50)\cf1 ,
\par @p_\cf2 Password\cf1  \cf2 varchar(50)\cf1 ,
\par @p_\cf2 CPassword\cf1  \cf2 varchar(50)\cf1 ,
\par @p_\cf2 PhoneNo\cf1  \cf2 varchar(50)\cf1 
\par )
\par 
\par AS 
\par 
\par Begin
\par \tab\tab Update \cf2 Users\cf1  set
\par \tab\tab\cf2 UserID\cf1 =@p_\cf2 $Field,
\par Name\cf1 =@p_\cf2 $Field,
\par Password\cf1 =@p_\cf2 $Field,
\par CPassword\cf1 =@p_\cf2 $Field,
\par PhoneNo\cf1 =@p_$Field
\par 
\par \tab return 
\par 
\par End\cf0 
\par }
"
