Finding tables and columns by name in a large Sybase database
Dec 7th
When working with a large Sybase database, especially one that you are not too farmiliar with, the following SQL snippets can be really useful for finding your way around.
select name,type from sysobjects where (name like '%Sales%') and type = 'U'
The sysobjects table stores data about various items in the database including tables (note that [...]
Formatting dates in Sybase
Jul 1st
It’s easy to format dates using the convert function in Sybase, but it’s less easy to remember the cryptic formatting style codes that go with it. This post lists the formatting styles.
