pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedProblem with SQL stored procedure
2+ messages / 2 participants
[nested] [flat]
* Problem with SQL stored procedure
@ 2006-12-08 11:27 sid tow <siddy_tow@yahoo.com>
0 siblings, 1 reply; 2+ messages in thread
From: sid tow @ 2006-12-08 11:27 UTC (permalink / raw)
To: pgsql-sql
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Problem with SQL stored procedure
@ 2006-12-08 11:39 Shoaib Mir <shoaibmir@gmail.com>
parent: sid tow <siddy_tow@yahoo.com>
0 siblings, 0 replies; 2+ messages in thread
From: Shoaib Mir @ 2006-12-08 11:39 UTC (permalink / raw)
To: sid tow <siddy_tow@yahoo.com>; +Cc: pgsql-sql
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.<http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=36035/*http://music.yahoo.com/unlimited/;
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-12-08 11:39 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-12-08 11:27 Problem with SQL stored procedure sid tow <siddy_tow@yahoo.com>
2006-12-08 11:39 ` Shoaib Mir <shoaibmir@gmail.com>
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