Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id B6F779F9EED for ; Fri, 8 Dec 2006 07:39:07 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 67477-02 for ; Fri, 8 Dec 2006 07:39:03 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0102.google.com (nz-out-0506.google.com [64.233.162.227]) by postgresql.org (Postfix) with ESMTP id 33B499F9C35 for ; Fri, 8 Dec 2006 07:39:07 -0400 (AST) Received: by nz-out-0102.google.com with SMTP id i11so490956nzh for ; Fri, 08 Dec 2006 03:39:06 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=iVSRS3JDYtiV0r0rDMB/hB6plZ8bX7By9CZUg/nwOLho2fERNmLxnVrOWN4bzXSjkYem5U+OxXbHuaPUvgMj64Vi0yZjiGRosf2yP2JfZiFMAqihqj+a6FXIw8EXefzVX6OOOzxvzxB/96g1iPo+Hfwab6Urxx40RuAwJWuASC0= Received: by 10.65.243.18 with SMTP id v18mr2645376qbr.1165577945616; Fri, 08 Dec 2006 03:39:05 -0800 (PST) Received: by 10.65.206.18 with HTTP; Fri, 8 Dec 2006 03:39:05 -0800 (PST) Message-ID: Date: Fri, 8 Dec 2006 16:39:05 +0500 From: "Shoaib Mir" To: "sid tow" Subject: Re: Problem with SQL stored procedure Cc: "Postgres SQL language list" In-Reply-To: <20061208112759.12757.qmail@web36703.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_35069_29388122.1165577945568" References: <20061208112759.12757.qmail@web36703.mail.mud.yahoo.com> X-Archive-Number: 200612/82 X-Sequence-Number: 27038 ------=_Part_35069_29388122.1165577945568 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Wrong mailing list to ask this :-) Try out a MS SQL Server one and you will get good help on that... Regards, Shoaib On 12/8/06, sid tow wrote: > > Hi all > > 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. > I am trying 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 string. Now the problem is that the parameters that I supply to the > stored procedure are returned back with out being modified, but I expect > some modifications to happen to those parameters. And if I comment out the > Print statement I get what I desire. Can somebody explain what exactly is > happening here? > > Regards, > Syed > > ----- Original Message ---- > From: ivan marchesini > To: Postgres SQL language list > Sent: Monday, November 13, 2006 10:02:06 PM > Subject: [SQL] drop a check > > Dear all... > I have created a check constraint without giving it a name.. > now I have a check named "$25" in my table that I need to drop or > modify!!! > How can I do??? > with names is simple > > alter table tablename drop constraint constraintname; > > but without name?? :-) > > many thanks... > > Ivan > > > > > -- > Ivan Marchesini > Department of Civil and Environmental Engineering > University of Perugia > Via G. Duranti 93/a > 06125 > Perugia (Italy) > e-mail: marchesini@unipg.it > ivan.marchesini@gmail.com > tel: +39(0)755853760 > fax: +39(0)755853756 > jabber: geoivan73@jabber.org > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > > > ------------------------------ > Access over 1 million songs - Yahoo! Music Unlimited. > ------=_Part_35069_29388122.1165577945568 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Wrong mailing list to ask this :-)

Try out a MS SQL Server one and you will get good help on that...

Regards,
Shoaib

On 12/8/06, sid tow <siddy_tow@yahoo.com> wrote:
Hi all

       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.
I am trying 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 string. Now the problem is that the parameters that I supply to the stored procedure are returned back with out being modified, but I expect some modifications to happen to those parameters. And if I comment out the Print statement I get what I desire. Can somebody explain what exactly is happening here?

Regards,
Syed

----- Original Message ----
From: ivan marchesini < marchesini@unipg.it>
To: Postgres SQL language list <pgsql-sql@postgresql.org>
Sent: Monday, November 13, 2006 10:02:06 PM
Subject: [SQL] drop a check

Dear all...
I have created a check constraint without giving it a name..
now I have a check named "$25" in my table that I need to drop or
modify!!!
How can I do???
with names is simple

alter table tablename drop constraint constraintname;

but without name??   :-)

many thanks...

Ivan




--
Ivan Marchesini
Department of Civil and Environmental Engineering
University of Perugia
Via G. Duranti 93/a
06125
Perugia (Italy)
e-mail: marchesini@unipg.it
        ivan.marchesini@gmail.com
tel: +39(0)755853760
fax: +39(0)755853756
jabber: geoivan73@jabber.org




---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend


Access over 1 million songs - Yahoo! Music Unlimited.

------=_Part_35069_29388122.1165577945568--