Lab Sql

I've been working on a small but somewhat complex Rails application with multiple has_and_belon… Read more Sqlexception On Db:test:load With Rails

We have a site which has sub domains like: example.com - Main Site food.example.com fashion.exa… Read more Design Users Table For Single Sign In To Use Across Sub Domains

I created a product / review system from scratch and I´m having a hard time to do the following que… Read more Designing And Querying Product / Review System

How do I insert current date into a row's column in the 'Edit data' view in MS SqlServe… Read more How To Insert Current Date In Row's Column

I have a simple MySQL database with some foreign keys on certain table columns. Some of the foreig… Read more Mysql Rejects Column With On Delete Set Null But Not On Delete Cascade

I've finished building my blog using EF and Code First. EF was running against my local SQL Exp… Read more Change Entity Framework Database Schema Map After Using Code First

I have got a table structure which is as follows: `CREATE TABLE 'pages' ( 'id' I… Read more What Is Bad In This Table Schema Structure

Is there some SQL that will either return a list of table names or (to cut to the chase) that would… Read more How Can I Retrieve A List Of All Table Names From A Sql Server Ce Database?