Lab Sql

Am trying to Fetch Only one record from the Sybase Table without using the RowCount Function, even … Read more Select Top 1 * From Table Fails In Sybase Procedure

I'm using Sybase ASE 15.5 and a stranger to this database. Straight to the point--> I'm … Read more Sql Query To Get Primary Keys For All Tables In Sybase Ase 15.x Along With Column Names

I'm trying to combine matching records from a table into a single record of another table. I kn… Read more Using Merge To Combine Matching Records

I have an attribute-value table av that looks like this: | attribute | value | ~~~~~~~~~~~~~~~~~~~~… Read more Are There More Elegant Ways Of Querying Data Based On Values Stored In Attribute-value Table?

I have to know the data type of some columns in my table in Sybase ASE. Here is my query select nam… Read more How To Get Proper Column Types In Sybase

I have a column named Cons in a table named Conses as Order::Resource(PPP32#BB300320LQ00J#AAAR05504… Read more How To Get Part Of The Column Value In Sybase Where This Column Situated In A Query Which Is Inside Other Query?

I am trying to migrate some legacy procedural code. I am having trouble figuring out the ANSI stand… Read more Sybase *= To Ansi Standard With 2 Different Outer Tables For Same Inner Table

I need help to understand this matter, what's the difference between the 2 queries below, all I… Read more Difference Between Left Join And *= In Sybase Ase 15