Lab Sql

(Using SQL Server 2008) I could easily get this to work if I built a view, and then a query on the … Read more Sql Running Total Grouped By Date

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 working on a SQL Server face problem which is splitting a string. I want to implement a functi… Read more Split String Put Into An Array

What's the best way to perform a groupwise maximum using Laravel's Eloquent ORM such that i… Read more Performing A Groupwise Maximum In Laravel 4

When updating records some DateTime values may look like 2015-06-25T01:35:52Z or 13 jun 2014 So whe… Read more Updating Sql Server Datetime Columns In Vb.net

I'm using a django application which does some 'startswith' ORM operations comparing lo… Read more Sql 'like Binary' Any Slower Than Plain 'like'?

How can I make sure that with this join I'll only receive the sum of results and not the produc… Read more Sql Query Returns Product Of Results Instead Of Sum

I am using SQL Server 2012. I want to create a row_number based on whether the index in subsequent … Read more Create Partition Based On The Difference Between Subsequent Row Indices In Sql Server 2012

I am working with test data in Visual Studio's server explorer. How would I put images into the… Read more Insert Image Into Sql Server 2008 Express Database Without Front End Application

i am storing images to the database. How to retrieve all the images from the database. Eg: select i… Read more Retrieve Images From Sql Server Database

I have seen some guidance which recommends that you secure a database by layering all data access t… Read more What Security Benefits Are Provided By Using Stored Procedures To Access Data?

I don't whats issue with this query and after multiple times trying I'm unable to run. Kind… Read more Subqueries Basic Error Before Execute

I have an update statement in a stored procedure that looks generally like this: Update [TABLE_NAME… Read more Sql Stored Procedure: If Variable Is Not Null, Update Statement

How to find ten most search distinct destinations for 10 minutes interval? user_id … Read more How To Get Result Based On 10 Minutes Interval In Mysql

I need to check the exit status (success/failure) of a query run through SQLCMD utility. For exampl… Read more Return Value Of Sqlcmd

How to reverse a field in SQL Server 2008 Solution 1: select reverse ( 'abcdef' ) ----… Read more How To Reverse A Field In Sql Server 2008

I want to return search results in paginated format. However I can't seem to successfully get t… Read more Paginating With Sql Row_number

Does anyone know the way of building table 2 with information in table 1? It is easy to approach wi… Read more Manipulate Login Logout Data With T-sql In Sql Server

I have many tables with the same model structure but with other table names with other data (in thi… Read more Dynamic Table Name With Entity Framework

Seems like i'm having fundamental problems using MAX - it's mixing the contents of rows, i … Read more Mysql Max Function Mixing Rows

I have a indexed table where one of the indexed columns can contains data with an underscore. ID N… Read more Fulltext Search Over Data With Underscore

For some reason (I have no control over this) dates are stored as Integers in an iSeries AS400 DB2 … Read more Db2 Convert Number To Date

SET NOCOUNT ON stops the message that shows the count of the number of rows affected by a Transact-… Read more Set Nocount On And Reading Messages Using C# And Ado.net

I got same problem in one more stored procedure. I want to add leave request to a SQL Server 2008 … Read more Return Value From Stored Procedure To C#

I want to check if the connected user is a SQL Server admin (in the sysadmin role) and wondering if… Read more Sql Smo - Checking If A User Is A Server Admin

DECLARE @cols AS NVARCHAR(MAX), @query AS NVARCHAR(MAX) select @cols = STUFF((SELECT ',' … Read more Sql Dynamic Pivot For Multiple Columns

In SQL Server 2012, can I create a foreign key constraint that includes a restriction on which rows… Read more Foreign Key With Additional Relationship Constraint

I have just moved one of my projects into VS2010/fx4.0 and am using a SQL CE database as the backin… Read more C# 4.0/ef - Server-generated Keys And Server-generated Values Are Not Supported By Sql Server Compact

I am a beginner in linq to sql, I am wondering what is the syntax in for a select inside a inner jo… Read more Linq To Sql Select Inside An Inner Join

I have the following query: SELECT table_1.id FROM table_1 LEFT JOIN table_2 ON (table_1.id = tabl… Read more Select Query With Three Where Conditions Is Slow, But The Same Query With Any Combination Of Two Of The Three Where Conditions Is Fast

In SQL Server 2008, why do the following queries return the same value? -- These all return 2011-01… Read more Sql Server 2008 And Milliseconds

I wanted to see what others have experienced when working with types like List or Dictionary and … Read more Storing A Dictionary Or Keyvaluepair In A Database

I'm using sqlalchemy with Elixir and have some troubles trying to make a query.. I have 2 entit… Read more Sqlalchemy+elixir: How Query With A Manytomany Relationship?

I recently inherited some code that is having occasional time-out issues. I am mostly familiar with… Read more Sqlparameter And Executenonquery Causing Unrepeatable Time Outs

This is a continuation of my previous question The query is given below, taken from this answer sel… Read more How To Match A Column Result From Query Result To A Table Column Value And Get More Columns From Same Table?

Let's say there is a schema: |date|value| DBMS is SQLite. I want to get N groups and calculate… Read more Sql: Grouping To Have Exact Rows

I'm pondering the design of an application where the main feature revolves around the ability t… Read more Find All Sets Which Are A Subset Of A Superset In Sql

I'm using laravel 4.2 and I have the following table that looks like this ID|chosen(boolean(… Read more How To Display A User Determined By The Maximum Number Rows

This is my school project. I am in chrage of eForum portion. I tried to delete a user and all the t… Read more Synchronize Data In Two Database Table Upon Deletion

Here is the following code to create two tables and a view in SQLite: CREATE TABLE foo(id TEXT); CR… Read more Why Is Sqlite Refusing To Use Available Indexes?

I am trying to get the latest booked courses (unique). I have tried the following with the Doctrine… Read more Symfony Doctrine Orderby And Group By (distinct)

I basically have an xml column, and I need to find and replace one tag value in each record. Soluti… Read more Can I Do A Find/replace In T-sql?

Oracle Live SQL. I am trying to insert records for a table. The table goes through just fine but in… Read more Sql - Ora-00911 - Invalid Character While Trying To Insert Records

I am trying to create the SQLite database of my app in an external seperate folder dynamically.Is t… Read more How To Dynamically Create Sqlite Database In External Folder?

I have a Postgres 9.6 installation on a developer pc and a restore seems to have failed. Even after… Read more Sql Command To Stop Job In Pgadmin 4

Which customer(s) ordered the most different books? Display the customer id and include ties. This … Read more Needing Assistance With Counting The Most Different Books

Using SQL Server 2012, is it possible to eliminate the need to declare a table-valued parameter (TV… Read more Create And Pass A Table-valued Parameter In A Single Line

Admin panel works fine, but on front-end I get following error. SQLSTATE[23000]: Integrity constrai… Read more Magento Upgrade 1.7 Caused Following Error

I am trying to create an autocomplete TextField. This one is working when I used the below hardcode… Read more Flutter - Textfield Auto Complete Suggestions From Sqlite

I have a problem where I need to parse a bunch of XML files into a SQL database where the needed el… Read more Parsing Xml Into Sql With Elements At Different Levels Of Xml Tree

I create the following tables: create table customers ( ID varchar(9), … Read more Select A Specific Customer In Mysql?

I have a table in BigQuery with millions of rows, and I want to split adx_catg_id column to multipl… Read more Split String Into Multiple Columns With Bigquery