C / C++ / MFC

<br />
USE myDB<br />
IF EXISTS (SELECT name FROM sysobjects <br />
         WHERE name = 'updatedata' AND type = 'P')<br />
   DROP PROCEDURE updatedata<br />
GO<br />
USE myDB<br />
GO<br />
CREATE PROCEDURE updatedata <br />
   @n1 decimal,<br />
   @n2 decimal,<br />
   @n3 varchar(25),<br />
    <br />
AS <br />
<br />
set nocount on<br />
<br />
DECLARE @m1 int<br />
DECLARE @m2 int<br />
<br />
... do initial process ....<br />
<br />
select @m1 = (select count(*) from table <br />
	      where params match)<br />
// @m1 should = 1<br />
<br />
... do second process ...<br />
<br />
select @m2 = 10 * (select count(*) from table <br />
	      where params match)<br />
// @m2 should = 10<br />
<br />
return (@md + @mdh)<br />
// should return 11 to calling app<br />
<br />
GO<br />
<br />

<br />
declare @val int<br />
exec @val = updatedata 101002, 105041, 'some part number'<br />
select @val as 'val'<br />

<br />
// RS1 is the recordset object<br />
char rsSQL[256];<br />
sprintf(rsSQL,"exec updateData %d, %d, %s", (long)tme, (long)jdt, cmLITM);<br />
RS1->Open(rsSQL, vtMissing, adOpenKeyset, adLockBatchOptimistic, -1);<br />

<br />
<br />
Something in the way she moves<br />
Attracts me like no other lover<br />
Something in the way she woos me<br />
<br />
I don't want to leave her now<br />
You know I believe her now<br />
<br />
Somewhere in her smile she knows<br />
That I don't need no other lover<br />
Something in her style that shows me<br />
<br />
Don't want to leave her now<br />
You know I believe her now<br />
<br />
You're asking me will my love grow<br />
I don't know, I don't know<br />
You stick around now it may show<br />
I don't know, I don't know<br />
<br />
Something in the way she knows<br />
And all I have to do is think of her<br />
Something in the things she shows me<br />
<br />
Don't want to leave her now<br />
You know I believe her now<br />
<br />