Lab Sql

We have the following account table (MySQL RDBMS): +----+-------------------+----------------+-----… Read more How To Create New Comma-separated Column From Existing Data?

Is there a way to determine whether a record was matched or not (whether the record was inserted or… Read more Determining SQL MERGE Statement Result

I have restaurants for which I have the following information in postgis: Last name longitude latit… Read more How Do I Search For Restaurants In A Region In A Country?

I'm sure this is a simple issue, but I'm trying to combine 2 columns into a new output colu… Read more Assign Value To SSIS Script Component New Output Column

I want to split the below string (present in a single column) separated by spaces from the end. For… Read more How To Apply Split_part Function From End Of String In Postgres

Firstly please understand that SQL is not one of my strong areas at the moment and i am a little un… Read more SQL Insert? Insert Data From One To Another

On a windows store app project i get a JSON from a webservice that looks like this:http://paste2.or… Read more Sqlite Not Recognizing Generic List

I wonder if the following is possible with fts(3/4) for SQLite. I created a table with some data us… Read more SQLite Full Text Search Catalog

A colleague of mine discovered a behaviour in SQL Server which I was unaware of. CREATE VIEW dbo.vR… Read more Is This A Good Or Bad Way Of Generating Random Numbers For Each Record?

How can I handle an array in a prepared statement? i.e, I want to do a query and one of the paramet… Read more Java - Prepared Statements And Arrays

Android, implementing SQLite These are the tables i have: http://postimg.org/image/jafsx39h7/ I hav… Read more SQLite, Tables, Joining

I'm new to so alembic so i might miss a point in its concept but here is the question. i have s… Read more Prevent Alembic From Autogenerating Tables

I have a database structure that's sort of like this: nodes id properties id node_id n… Read more How To Query For Values Which Have The Highest Vote Count And No Flags In PostgreSQL?

I want to create or update a view using stored procedure like this: CREATE PROC Proc_Get_Ready_Weap… Read more Creating / Updating View Using Stored Procedure

I'm having a little bit of a problem that I thought was related to Security but, turns out can&… Read more Attempt To Write A Read-only Database - System.Data.SQLite

i have the following sql query to get an idea of what it does please read the description below sel… Read more SQL Add Processed Ids To A Single Cell Seperated With A Comma

I am trying to do a simple filter operation on a query in sqlalchemy, like this: q = session.query(… Read more SQLAlchemy Filter In_ Operator

I am sure this is quite easy to find, but through my searching I have been unable to find a solutio… Read more SQL: How To Create Two Fields Based On Same Field From Another Table?

I tried to return the reference of FMResult object from a method and trying to access values from t… Read more How To Take Copy Of FMResultset In FMDB Sqlite

I have the below insert query which selects records from the OriginalData table where everything is… Read more Catching Multiple Errors In Loop SQL Query