| Thread | Last Post | Replies |
|
| selecting rows by DATETIME without providing the time? | 29 Aug 2008 19:42 GMT | 4 |
Say I'm looking for all rows with a timestamp field from "Jun 4 2008". Since the timestamp field also contains a time (in this case, 8:08AM), the following doesn't work: SELECT *
|
| How to print constraints. | 23 Aug 2008 05:24 GMT | 1 |
Dear Experts, Is it possible (and how is it) to print all constraints on a given table? Regards,
|
| grant in a stored proc | 22 Aug 2008 20:44 GMT | 2 |
I have a stored proc that create a table, renames it, then does a grant on it. It runs without errors, but the table does not get the permissions granted. Here is a small test that shows what I am talking about:
|
| Using ON EXISTING UPDATE on ASE | 22 Aug 2008 18:25 GMT | 1 |
I'm new on useing ASE 15 and I would like to use the statement similar to MySQL's REPLACE statement. I have surfed the web and found the article "MySQL to Sybase ASE Migrtion Guide", it said INSERT....ON EXISTING UPDATE as equivalent to
|
| optimizing sybase sql queries? | 11 Aug 2008 14:48 GMT | 4 |
In MySQL, if you want to see what the bottle neck of an SQL query is, you can prepend the query with EXPLAIN. Does Sybase offer similar functionality?
|
| Can a view be used inside a derived tables? | 08 Aug 2008 16:04 GMT | 6 |
We have a Nortel symposium telecoms system which uses Sybase to store details of all the calls etc. Now, Symposium does not allow access to the tables so we have to use pre-configed views.
|
| Unable to house keep the Sybase database | 07 Aug 2008 12:15 GMT | 1 |
We are trying to housekeep our sybase database. We have deleted the records from the DB. Surprisingly even though the records are deleted, the DB size is increasing. Upon deletion of some 5000 records it almost became 1 and 1/2 times.
|