From: sid tow <siddy_tow@yahoo.com>
To: Postgres SQL language list <pgsql-sql@postgresql.org>
Subject: Problem with SQL stored procedure
Date: Fri, 8 Dec 2006 03:27:59 -0800 (PST)
Message-ID: <20061208112759.12757.qmail@web36703.mail.mud.yahoo.com> (raw)
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
____________________________________________________________________________________
Any questions? Get answers on any topic at www.Answers.yahoo.com. Try it now.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: siddy_tow@yahoo.com
Subject: Re: Problem with SQL stored procedure
In-Reply-To: <20061208112759.12757.qmail@web36703.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox