Skip site navigation (1) Skip section navigation (2)

Re: Problem with SQL stored procedure

From: "Shoaib Mir" <shoaibmir(at)gmail(dot)com>
To: "sid tow" <siddy_tow(at)yahoo(dot)com>
Cc: "Postgres SQL language list" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Problem with SQL stored procedure
Date: 2006-12-08 11:39:05
Message-ID: bf54be870612080339h4ed484das295b90c0ade859e5@mail.gmail.com (view raw or flat)
Thread:
Lists: 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(at)yahoo(dot)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(at)unipg(dot)it>
> To: Postgres SQL language list <pgsql-sql(at)postgresql(dot)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(at)unipg(dot)it
>         ivan(dot)marchesini(at)gmail(dot)com
> tel: +39(0)755853760
> fax: +39(0)755853756
> jabber: geoivan73(at)jabber(dot)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/>
>

In response to

pgsql-sql by date

Next:From: Aaron BonoDate: 2006-12-08 14:09:10
Subject: Re: [HACKERS] Case Preservation disregarding case
Previous:From: sid towDate: 2006-12-08 11:27:59
Subject: Problem with SQL stored procedure

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group