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