Spark Sql Blog

I'm connecting to external MSSQL database for exports from PHP55/osx and I have wierd issue. co… Read more Php Pdo_mssql Sqlstate[01002] Adaptive Server Connection Failed (severity 9)

I have a SQLite database exported (as a sqlite format 3 file?) from Scraperwiki with the .sqlite fi… Read more Importing Files With Extension .sqlite Into R

I have two tables. Table A contains UserID, UserName Table B contains ID, FK_UserID, ClientName I n… Read more Options For Returning Distinct Values Across An Inner Join

I have created a table with a column of type nvarchar(max): CREATE TABLE Table1 (Col1 nvarchar(max)… Read more Remove Zero In A Column

i would like to select * from table where dates between (some_date and another_date) the problem is… Read more Mysql: Searching Between Dates Stored As Varchar

In HSQL to change TRANSACTION CONTROL there can't be any active transactions. Flyway, in turn, … Read more Changin Db Transaction Control In Flyway With Hsql

I have two particular model classes that are giving me errors during my testing, upon inspecting th… Read more Changes To Model Class's __init__ Method Don't Seem To Be Taking Effect

Can an SqlDataReader be passed to a session or sent to a client? For instance, if I retrieved some … Read more C# - Sqldatareader And Serialization

I am told that usage of SP_OACreate , SP_OAMethod in SQL Server 2000 is of a security risk. I am us… Read more Usage Of Sp_oacreate, Sp_oamethod Etc.. Is A Security Risk?

I want to use SQL Server to send email and found two possible way from the internet: Using AOSMTP.… Read more Sql Server : Send Email

I have a datagridview whose source is a datatable. There are orders and food names columns. I inser… Read more Datagridview Update

First, I try to connect to sql server of other computer(PC1-PC\Instance1) through ssms with Windows… Read more App Config - The Login Is From An Untrusted Domain

i am using the below query to return rowcount for paging, it works fine but take very long to retur… Read more Optimized Way To Get Row Count From A Query Contains Large Amount Of Data

I have worked a lot on codeigniter. In codeigniter , if there is need to get query string that is e… Read more How To Echo Last Query String In Phalcon?

Hello all i have this method in the database handler class and what this class do is to return the … Read more Android: Database Handler Sqliteexception

I would like to create a simple distance function to order objects while fetched from a SQLite data… Read more How To Create A Type-safe Custom Function In Sqlite.swift?

I need to create an SQL table or view that would generate columns for every month between a range o… Read more Creating Sql Table With Range Of Months As Columns And Populating Fields With Table Data

I want to insert multiple email into SQL Server table cell and before inserting them I need check w… Read more Match Comma-separated Values In Sql Server Column

I need to write SELECT statement selecting rows, where prefix of any word from some field matches g… Read more Search Matching Prefix Of Every Word In Field In Sqlite

I want to create a script that will have variables of _user and _pass to create the user in the Pos… Read more Creating User With Password From Variables In Anonymous Block

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 have a batch files which when i run calls a SQL file. This SQL file prompts user to input data w… Read more Issues When User Input Data In Sql Command

I am developing a GPS calculator that uses a lot of data to calculate different values, such as RMS… Read more Sqlite And Flex

I am trying to make a facebook style chat page using php. But i have a problem to showing old conve… Read more People Are Shown Twice On The Chat Page Because Of Query

I am facing a problem to connect to an Azure MS SQL Server 2014 database in Apache Airflow 1.10.1 u… Read more Apache Airflow - Connection Issue To Ms Sql Server Using Pymssql + Sqlalchemy

I have a table WEEK_ID WEEK_STARTDATE WEEK_YEAR WEEK_MONTH WEEK_CREATEDTS 252 10/26/2008 2008 … Read more To Get The Id's Between Two Dates

I am trying to use NHibernate in combination with .NET's TransactionScope object. So far I hav… Read more How Can I Use Transactionscope With Sql Compact 4.0 And Nhibernate

I've written an ASP.NET 4.0 application that is using a SQL Server CE 4.0 database. This is all… Read more Can I Use Sql Server Ce In A Medium Trust Environment By Just Deploying The Dlls

On SQL server 2008 R2, I would like to select one value of a column for each distinct value of ano… Read more Sql Server 2008 R2, Select One Value Of A Column For Each Distinct Value Of Another Column

I need help reading JSON file in MSSQL I have a json format like this { '_id':{ … Read more Reading File Containing Multiple Json Objects Using Ms Sql Server

Three tables, columns as follows: A: A_id, B_id, C_id, flag, ... B: B_id, date, ... C: C_id, … Read more Joins Based On Conditions In Multiple Tables

I've been given two tables: Employee and Staff |ID| Name |Surname|Postion| |EmpID|Ma… Read more Sql Table Output

connecting to a mysql database from java using jdbc. declaring a query String query = … Read more Java - Mysql - Select Query Outfile - Where Is File Getting Saved

Ok I have read online about using SQLite with java and read the question on here titled Java and SQ… Read more Java Sqlite For Dummies?

Varchar(max) column not allowed to be a Primary Key in SQL Server. What is the max length of a varc… Read more Varchar(max) Column Not Allowed To Be A Primary Key In Sql Server

I'm trying to understand the table operator APPLY. Here is the example: CREATE TABLE #y ( Name … Read more When To Use The Table Operator Apply

In my CREATE VIEW I would like to: SELECT CONCAT( t.str1, t.str2 ) AS Title, CHAR_LENGTH( Title ) A… Read more Mysql: Select Concat Of Strings And Length Of Resulting Concat

I have the MySQL version of this question for SQL-Server I'm running mysql Ver 14.14 Distrib 5… Read more How To Allow Insert Through Stored Procedure Only?

I have a user just_one_schema_user. In my database I have two schemas: public and sample How can I … Read more Grant Access To Just One Schema In Postgresql

I have the following dictionary of dataframes created from a folder of excel files: import os impor… Read more Python: Dataframes To Db

I have some code (see below) that populates a table with all the records. I however want to replace… Read more Replacing A Pulled Sql Id Value With Its Name From Another Table

Is it possible to order results in SQL Server 2005 by the relevance of a freetext match? In MySQL y… Read more Sql Server Freetext Match - How Do I Sort By Relevance

I am currently running into a challenge that probably has a easy solution, but somehow I am not abl… Read more Sql Server: Replace Values In Field Via Lookup Other Table