Home > Archive > PostgreSQL SQL > December 2006 > Re: Problem with SQL stored procedure









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: Problem with SQL stored procedure
Shoaib Mir

2006-12-08, 7:21 pm

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.y....com/unlimited/>
>


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com