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 wOOdy-Soft 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: *

  • Users: inaranjo
  • Content: Threads
  • Order by date
  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

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

Part and Inventory Search

Back
Top