Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Sybase Topics / August 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
selecting rows by DATETIME without providing the time?29 Aug 2008 19:42 GMT4
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 GMT1
Dear Experts,
Is it possible (and how is it) to print all constraints on a given
table?
 Regards,
grant in a stored proc22 Aug 2008 20:44 GMT2
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 ASE22 Aug 2008 18:25 GMT1
     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 GMT4
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 GMT6
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 database07 Aug 2008 12:15 GMT1
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.