I need to Retirve the following Details using Sybase SQL Query. 1) Database Data File Path 2) Database Transaction Log File Path 3) Path where SybaseSoftware Installed 4) Patch Installed on Sybase Thanks. ...
Dear Friends when i run sp_helpdb dbname query in sybase it return only following columns name,db_size,owner,dbid,created,status & not returning the following Columns device_fragments,size,usage,created,free kbytes I m using sybase Adaptive Server Enterprises Why this happend plz help me Thanks in advance ...
I need to selectively (both rows and columns) export around 20 million rows from one table to another. This is what I tried: --Run this in batch: INSERT INTO Table 2 Select A, B from Table1 where A > a and B < b ---Table1 have columns A, B....Z and got around 50 million records. It takes around 12 hours to finish. I don't think syb...