Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id A6EB09F9EED
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri,  8 Dec 2006 07:28:01 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024)
	with ESMTP id 48007-09 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri,  8 Dec 2006 07:28:00 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from web36703.mail.mud.yahoo.com (web36703.mail.mud.yahoo.com
	[209.191.85.37]) by postgresql.org (Postfix) with SMTP id A7CAD9F9C35
	for <pgsql-sql@postgresql.org>; Fri,  8 Dec 2006 07:28:00 -0400 (AST)
Received: (qmail 12759 invoked by uid 60001); 8 Dec 2006 11:27:59 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type;
	b=TvwqI/8f8pMDOEUwuZUQjejqGe2R30F1+d9jZIc7SXvkQcHYFQmkpMG8Nz6RJUERvMLh7UduQlcVwCmumu69UeTdciLKRN+Ff1u0V9ReJ968nnqEqF/xfXwNKtb9GDhlaCrCzhcNIDgDZVhQhCJgc8XZStUSxURzM+L9dS/BxHk=
	;
Message-ID: <20061208112759.12757.qmail@web36703.mail.mud.yahoo.com>
Received: from [203.126.136.220] by web36703.mail.mud.yahoo.com via HTTP;
	Fri, 08 Dec 2006 03:27:59 PST
Date: Fri, 8 Dec 2006 03:27:59 -0800 (PST)
From: sid tow <siddy_tow@yahoo.com>
Subject: Problem with SQL stored procedure
To: Postgres SQL language list <pgsql-sql@postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-692760956-1165577279=:12133"
X-Archive-Number: 200612/81
X-Sequence-Number: 27037

--0-692760956-1165577279=:12133
Content-Type: text/plain; charset=ascii
Content-Transfer-Encoding: quoted-printable

Hi all=0A=0A        I dont know if this is the right forum to post this but=
 any way if you could help me or guide me to an appropriate forum, I would =
appreciate it.=0AI am trying to call a SQL (SQL server 2000) stored procedu=
re from my c++ code and in that stored procedure I have a Print statement w=
hich will print some string. Now the problem is that the parameters that I =
supply to the stored procedure are returned back with out being modified, b=
ut I expect some modifications to happen to those parameters. And if I comm=
ent out the Print statement I get what I desire. Can somebody explain what =
exactly is happening here?=0A=0ARegards,=0ASyed=0A=0A----- Original Message=
 ----=0AFrom: ivan marchesini <marchesini@unipg.it>=0ATo: Postgres SQL lang=
uage list <pgsql-sql@postgresql.org>=0ASent: Monday, November 13, 2006 10:0=
2:06 PM=0ASubject: [SQL] drop a check=0A=0ADear all...=0AI have created a c=
heck constraint without giving it a name..=0Anow I have a check named "$25"=
 in my table that I need to drop or=0Amodify!!!=0AHow can I do???=0Awith na=
mes is simple=0A=0Aalter table tablename drop constraint constraintname;=0A=
=0Abut without name??   :-)=0A=0Amany thanks...=0A=0AIvan=0A=0A=0A=0A=0A-- =
=0AIvan Marchesini=0ADepartment of Civil and Environmental Engineering=0AUn=
iversity of Perugia=0AVia G. Duranti 93/a =0A06125=0APerugia (Italy)=0Ae-ma=
il: marchesini@unipg.it=0A        ivan.marchesini@gmail.com=0Atel: +39(0)75=
5853760=0Afax: +39(0)755853756=0Ajabber: geoivan73@jabber.org=0A=0A=0A=0A=
=0A---------------------------(end of broadcast)---------------------------=
=0ATIP 6: explain analyze is your friend=0A=0A=0A=0A=0A=0A=0A=0A =0A_______=
___________________________________________________________________________=
__=0AAny questions? Get answers on any topic at www.Answers.yahoo.com.  Try=
 it now.
--0-692760956-1165577279=:12133
Content-Type: text/html; charset=ascii
Content-Transfer-Encoding: quoted-printable

<html><head><style type=3D"text/css"><!-- DIV {margin:0px;} --></style></he=
ad><body><div style=3D"font-family:times new roman, new york, times, serif;=
font-size:12pt"><div style=3D"font-family: times new roman,new york,times,s=
erif; font-size: 12pt;">Hi all<br><br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;  I do=
nt know if this is the right forum to post this but any way if you could he=
lp me or guide me to an appropriate forum, I would appreciate it.<br>I am t=
rying to call a SQL (SQL server 2000) stored procedure from my c++ code and=
 in that stored procedure I have a Print statement which will print some st=
ring. Now the problem is that the parameters that I supply to the stored pr=
ocedure are returned back with out being modified, but I expect some modifi=
cations to happen to those parameters. And if I comment out the Print state=
ment I get what I desire. Can somebody explain what exactly is happening he=
re?<br><br>Regards,<br>Syed<br><br><div style=3D"font-family: times new rom=
an,new
 york,times,serif; font-size: 12pt;">----- Original Message ----<br>From: i=
van marchesini &lt;marchesini@unipg.it&gt;<br>To: Postgres SQL language lis=
t &lt;pgsql-sql@postgresql.org&gt;<br>Sent: Monday, November 13, 2006 10:02=
:06 PM<br>Subject: [SQL] drop a check<br><br><div>Dear all...<br>I have cre=
ated a check constraint without giving it a name..<br>now I have a check na=
med "$25" in my table that I need to drop or<br>modify!!!<br>How can I do??=
?<br>with names is simple<br><br>alter table tablename drop constraint cons=
traintname;<br><br>but without name??&nbsp;&nbsp; :-)<br><br>many thanks...=
<br><br>Ivan<br><br><br><br><br>-- <br>Ivan Marchesini<br>Department of Civ=
il and Environmental Engineering<br>University of Perugia<br>Via G. Duranti=
 93/a <br>06125<br>Perugia (Italy)<br>e-mail: marchesini@unipg.it<br>&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ivan.marchesini@gmail.com<br>tel:=
 +39(0)755853760<br>fax: +39(0)755853756<br>jabber:
 geoivan73@jabber.org<br><br><br><br><br>---------------------------(end of=
 broadcast)---------------------------<br>TIP 6: explain analyze is your fr=
iend<br></div></div><br></div></div><br>=0A=0A<hr size=3D1>Access over 1 mi=
llion songs - <a href=3D"http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=3D=
36035/*http://music.yahoo.com/unlimited/">Yahoo! Music Unlimited.</a></body=
></html>
--0-692760956-1165577279=:12133--