Lab Sql

I am attempting to make a stored procedure that uses sp_executesql. I have looked long and hard he… Read more Using Sp_executesql With Params Complains Of The Need To Declare A Variable

I am developing a web application using ASP .NET 2.0, VS 2008 and SQL Server 2005. I would like to … Read more SQL Server 2005 Reporting Services - Pros And Cons

I want to update rows in my table with starting from 1001 to next 1000. I tried with following quer… Read more MySQL - UPDATE Query With LIMIT

I am trying to convert a column which is in upper case to proper case but with exceptions like cert… Read more Proper/Title Case A Column With Exceptions Table In SQL Server

I have data with info similar to the below: Customer Start End AAA 100 399 BBB … Read more How Can I Generate Rows In A SQL Table To Break Up A Range Into Induvidual Rows

I am having problems deploying a ssas cube in Azure. I have designed a cube in SSDT. The structure … Read more Problems Deploying A SSAS Cube In Azure

Consider the following code snippet: $beat = date('B'); // 1 beat = 86.4 seconds, 1000 beat… Read more How Can I Optimize These Queries?

I have a table inquiry with columns job, gender (TRUE for women, FALSE for men) and salary. None of… Read more Unique Results For SQL Command With GROUP, MIN And NULL Values

i have this SQL statement I want to combine 'date' and 'dayOfWeek' Column SELECT C… Read more How To Combine Two Data Columns?

I'm using MySQL workbench to design a database. Server is mysql 5.5.6 I've defined a few fo… Read more Mysql: Using Two Foreign Keys To The Same Table

I have the following tables: movies genres genres_movies ------ ------ ------------… Read more Node Express And SQLite3: Return Related Many-to-many Data As One Object

I am creating C# winforms application, which connects to the Database. Because I have a many record… Read more How To Select Data From Database With Many Filter Options?

In SQL SERVER 2008 R2 I have 7 databases, each one with around 1000 tables. I need to know wich tab… Read more Getting Last User Update Time For All Tables In A Database

These are my rows that I initially retrieved: 112 Cem Ceminay 210 Ali Salih 132 Gül Sen… Read more How To Retrieve Rows Multiple Times In SQL Server?

Given a SQL table Transactions ID INT COMPANY_ID INT STATUS INT where S… Read more Summarizing Two Conditions On The Same SQL Table

Pretend I have a table with 2 columns. _id and name. _id is the primary key and I do not want to … Read more SQLite And Android Insert/Updates On SQLiteDatabase -CompiledStatements-

Using vbscript i am trying to add data to access database. I am successfully able to add data to d… Read more Check For Duplicate Entries Before Adding Data To Access Database

I have a basic write to and retrieve SQL database PHP 'thing' and I want to have the output… Read more How To Reverse Order Output Of A MySQL Query

I have got a little problem with SQL. I'm trying to insert 2 values into my table. that's m… Read more INSERT INTO PostgreSQL

I'd like to do something like this: SELECT t1.*, t2.* FROM t1 LEFT JOIN t2 ON t1.id=t2.id AND t… Read more ACCESS LEFT JOIN With Multiple Criteria

I have a product model with a many to many relationship to product_categories as described below: c… Read more SQLAlchemy Attempting To Twice Delete Many To Many Secondary Relationship

Given a large table (10-100 million rows) what's the best way to add some extra (unindexed) col… Read more PostgreSQL: Performance Impact Of Extra Columns