From: | sid tow <siddy_tow(at)yahoo(dot)com> |
---|---|
To: | Postgres SQL language list <pgsql-sql(at)postgresql(dot)org> |
Subject: | Problem with SQL stored procedure |
Date: | 2006-12-08 11:27:59 |
Message-ID: | 20061208112759.12757.qmail@web36703.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(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
____________________________________________________________________________________
Any questions? Get answers on any topic at www.Answers.yahoo.com. Try it now.
From | Date | Subject | |
---|---|---|---|
Next Message | Shoaib Mir | 2006-12-08 11:39:05 | Re: Problem with SQL stored procedure |
Previous Message | Tom Lane | 2006-12-07 23:42:56 | Re: could not find pathkey item to sort |