Sybase Transact SQL Workshop

Author: rocket99.com | Published: 19th Aug 2005 | Visited: 1501 times | Add Comment
Filed in: Sybase

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 Article

Sponsored Links

• Using BEA Workshop and Java to create Flex-based rich Internet applications Learn how to use this Flex-specific bundle from BEA to create an RIA using Java for the back-end business logic and Flex for the front-end interf ...

• DAL Class and Transact-SQL generator for C# and VB.Net Automatically generates required class and stored procedure to work with sql datab ...

• DAL Class and Transact-SQL generator for C#.Net Automatically generates required class and stored procedure to work with sql datab ...

• The Baker's Dozen: 13 Productivity Tips for Transact-SQL 2005 SQL Server 2005 offers T-SQL language features that can improve your productiv ...

• Unable to use boolean fields with Sybase ASA 9 QC#: 46160 Version: 11.0 Status: New defect, requires tester review Description: It is possible to add a boolean field, but it only accepts the value "false". This was not a problem in DBX3, where "true" was converted to 1. In DBX4 it seems to be con ...

• Workshop: How to Achieve High Performance SOA with Multi-Core and Software Pipelines According to market researchers at IDC, multi-core technology may be one of the most significant industry developments of the past 40 years1. To take advantage of new hardware paradigms, however, enterprise software applications must be adapted to use concurrent processing methods. Come join techni ...

• [W3C:Call for Participation] International Workshop on the future of the Extensible Stylesheet Langu... XSL-FO 2.0 Workshop 2006 W3C will hold a workshop in Heidelberg, Germany, to gather inspiration, needs and techniques for a future version of XSL-FO, the formatting specification of the Extensible Stylesheet Language (XSL). The W3C XSL Working Group expects tha ...

• Sybase DataWindow .NET 2.0—Easy, Powerful, and Flexible Sybase's DataWindow .NET control simplifies and unifies the process of building both Windows and Web reporting and data-entry applications—without compromising your control of either the data or the visual st ...

• (Pulled) SQL Explorer has errors when viewing the 'Text' definition of some items w/ a Sybase 11.9.2... QC#: 17893 Version: 5.0 Status: Closed defect, no action required Resolution: Bug has been fixed Description: SQL Explorer has errors when viewing the 'Text' definition of some items w/ a Sybase 11.9.2 database. I'm not sure if its a problem with 11.9.2 or a problem w/ Sybase in gene ...

• Register for Oracle Developer Day (FREE Developer Workshop) Get insight into the latest Java and SOA technologies in this free hands-on workshop. Next stops include New York City (Sept. 29); Pasadena, Calif. (Oct. 11); Toronto (Oct. 18); and Montreal (Oct. ...

Next: Sybase Database Administration