Hi,
Is it valid to perform a commit inside a store procedure?
I have a procedure that performs many selects and updates but it doesn't have a commit. I'm new in sybase, so I don't know if this would cause the procedure to go slower.
How can I do this?
Thanks,
Hi,
Does any one know how to obtain a date format "Mon dd yyyy hh:miAM" from "yyyy-mm-dd" adding the seconds?
In Oracle I can use the following:
select to_char(to_date('2004-09-30','yyyy-mm-dd hh24:mi:ss')+(86346/86400),'Mon dd yyyy hh24:mi:ss') from dual
Being 2004-09-30 the date and 96346...
Hi every one,
I have to add three fields to a table, but it currently has over 16'000.000 records. Last time this was done (over 9 months ago) the data was backup up with the BCP out command, then the table was recreated with the new fields and a BCP in was performed.
The problem is that with...
Hi,
Sorry I'm new in Sybase, but have you considered doing a dump database instead a BCP. I had problems with the BCP cmd with big tables, so the dump cmd really helped out and it takes less time also.
Bye
Hi,
Have you tried a while sentence in your SP?
i.e.
While @diff <= 0
begin
update....
...
if @diff < 0
...
else
select @diff = 1 => to exit loop
end
Hope this helps
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.