Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. inaranjo

    Commit within a store procedure

    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,
  2. inaranjo

    Convert Datetime

    Sorry, Im using Sybase 12.0
  3. inaranjo

    Convert Datetime

    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...
  4. inaranjo

    Alter table command

    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...
  5. inaranjo

    Testing if a table is empty

    Hi all, I know this is late, but the command sp_spaceused tableName could help you too. Regards,
  6. inaranjo

    Help! BCP Issue

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

    How to do Loop in a store procedure?

    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

Part and Inventory Search

Back
Top