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 <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
        [EMAIL PROTECTED]
tel: +39(0)755853760
fax: +39(0)755853756
jabber: [EMAIL PROTECTED]




---------------------------(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.

Reply via email to