Thread: Problem with SQL stored procedure
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
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
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
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.
Wrong mailing list to ask this :-)
Try out a MS SQL Server one and you will get good help on that...
Regards,
Shoaib
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 checkDear 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.