Lab Sql

I want to modify the following DDL to add CHECK constraints so that the manager of a store works at… Read more Adding Check To Impose Constraints On More Than One Table

I have a backup of a database from a week ago. I need to import this into MySQL without access to t… Read more Import Backed-up Sql Anywhere 10 .db File Into Mysql 5.1

In my case, using sql anywhere (sybase). Something similar to haskell. [1..100]. I don't know h… Read more How To Generate A List Of Number In Sql As It Was A List Of Comprehension?

My question is somewhat the same as Python list of String to SQL IN parameter but I have a list of … Read more Python List Of Ints In Prepared Sql Statement

Yes, you can find similar questions numerous times, but: the most elegant solutions posted here, wo… Read more How To Delete Duplicate Rows In Sybase, When You Have No Unique Key?

I am building a query using ODBC command object in .Net with multiple parameters being passed in. W… Read more Sql Anywhere Query Error: Not Enough Values For Host Variables

This is related to this question but slightly different, I have while loop that inserts records and… Read more How To Continue Executing Rest Of While Loop Even If An Exception Occurs In Sybase?

I have two tables, and want to extract certain columns from the first, based on 'child' dat… Read more Sql Subselect Filtering Based On Multiple Sub-rows