Sybase Transact SQL Workshop

This tutorial cover the following topics in Sybase. Sybase data types Listing object names and attributes Creating a table Creating a proxy table Altering a table Creating an index Clustered vs non-clustered indexes Creating a constraint Table partitioning Tables which span multiple segments Creating a stored procedure Object permissions Transact SQL Primer Transact SQL: Numeric functions Transact SQL: String functions Transact SQL: Date functions Transact SQL: Date formats Transact SQL: Misc functions Transact SQL: Conditionals Transact SQL: Loop constructs Transact SQL: Cursors Transact SQL: Complex updates Transact SQL: Counting duplicate rows Transact SQL: Using temporary tables Transact SQL: Inner and Outer Joins Transact SQL: Isolation Transact SQL: Writing Reports Transact SQL: Case Statement

Read More...

---