Spark Sql Blog

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

Application connected to MS SQL Server will create views where a single row result is an analysis i… Read more How To Mimick Oracle Materialized Views On Ms Sql Server?

My table 'DATA123' is as follows NoticeDate------Amount 2016-02-14------60000 2015-11-06---… Read more Order By Year, Month Along With Cumulative Sum

I got AdventureWorks2012 DB from http://msftdbprodsamples.codeplex.com/releases/view/55330 and tryi… Read more Adventureworks2012 Db - How The Password Was Stored And How The Password Validated?

The following Query1 is fine with Oracle. I want the same functionality to be carried out in Derby.… Read more Oracle To Derby - Connectby And Start With Equivalent In Derby

I'm trying to compare dates using Linq to Entities on a SQLite database. The following code wor… Read more Can't Compare Dates Using Sqlite With Ef6

i need to find the difference between the time in the format hh:mm:ss select msglog.id,max(msglog… Read more Find The Elapsed Time Between Two Dates In Oracle Sql

I've been trying to execute the next sp. My target is to generate a string with the values of s… Read more Problems With The Execution Of A Sp In Sql

I know a typical way is like this: IQueryable query = from staff in dataContext.Staffs; if(name1 !=… Read more Linq: Adding Where Clause Only When A Value Is Not Null

I am getting an 'Object Was Open' error when opening a TADOQuery which returns a large data… Read more "object Was Open" Error Using Delphi, Sql Server And Ado

Hi my SQL is a bit rusty and need a bit help with getting a statement correct. I have the following… Read more Join Two Tables Based On Two Columns

First of all I don't know if my database is working since I ended up changing my previous code … Read more Android : How Can I Retrieve My Desire Data In My Database

I have JSON in a field, but I need to check it's schema before I process it. I need to know if … Read more Find Json Schema In Sql Server

I've seen many solutions to sync SQL Server data TO SharePoint, but nothing to sync SharePoint … Read more Real Time Sync From Sharepoint To Sql Server

I'm fairly new to MSSQL and SSRS. I'm trying to create a data driven subscription in MSSQL … Read more Data Driven Subscriptions Ssrs Standard Edition 2008

I have found a way to select random rows from a table in this post. A suggestion is to use the foll… Read more How To Use Limit Keyword In Sql Server 2005?

Please see the below flowchart. How can i really achieve it. It tried various things in the SSIS E… Read more Ssis Conditional Split, But Want To Check A Pattern

Im trying to make my menu auto generated using this for loop: q3 = connect_menu.addMenu('Q3'… Read more Using Database And Dict To Add Menus And Triggers

I'm trying to write a query on the below data set to add a new column which has some sort of &#… Read more Query To Identify Contiguous Ranges

Whenever the field sync is updated without the flag being YES I need to set that field to NULL. CRE… Read more Trigger On Update Firebird

I am reading a value from a key/value table that should contain a NULLABLE date with the format yyy… Read more Which Values Are Making The Conversion From Varchar To Date Fail?

My question is, can I create one trigger for multiple operations (insert/update/delete) on one tabl… Read more Create One Trigger For Multiple Operations

Here is my problem: My database have table Book, Post. Each book has many post Table posts has fie… Read more Different Result Query When Use Mysql And Mariadb

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

I am saving Image in a table in VarBinary and its working.but the problem is if i save image using … Read more Why Sql Server Image In Binary Causes Issue In String Query But Works In Parameterized Query

I have the following pivoting table that I manage to do and here's the result and I want to put… Read more Other Solution Instead Of Cursoring

I've got a problem with inserting two rows to table. The database is in UTF8. The problem seems… Read more Mysql, Polish Characters And Duplicate Insert Statement

I am trying to make a sub-table that 'stores' a decode between two values, because I need t… Read more Constructing A Temporary Table In Oracle Sql

I have an application where users can take tests (which are composed of questions and answers). I&#… Read more Problem Constructing Where Clause To Include Null/0 Values

I'm trying to LEFT JOIN two tables, to get a list of all rows from TABLE_1 and ONE related row … Read more Using Left Join To Only Selection One Joined Row

The purpose of this post is to find out why I cannot log into a remote SQL Server instance from a W… Read more Windows Firewall Rules For Sql Management Studio

The title of this question is not accurate but I didn't know how to summarize it. Please feel f… Read more Merge Tables With Postgresql

This is the query I am trying to execute: UPDATE TABLE users SET metadata = metadata - 'keyA… Read more Using Raw Value-expressions In Update With Jooq

I wrote raw query to psql and it's work fine but when i wrote this in sqlalchemy my WHERE claus… Read more Sqlalchemy Duplicated Where Clause To From

When inserting multiple rows in a MySQL-DB via a SQLA-Expression-Language statement, f.e. Foo.__tab… Read more Sqlalchemy Raw Sql Vs Expression Language Statements

Where I'm at there is a main system that runs on a big AIX mainframe. To facility reporting an… Read more Importing New Database Table

I have to find polygon overlaps and get their geometry. Does anybody have idea how to do that? This… Read more Find Polygon Overlaps

I have two tables, and want to extract certain columns from the first, based on 'child' dat… Read more Sql Subselect Filtering Based On Multiple Sub-rows

I know this is a bit vague, but I'm not being able to pinpoint the issue. When I run the a bit … Read more What Does "resetting The Connection" Mean? System.data.sqlclient.sqlexception (0x80131904)

I'm using an sqlite3 database to record data every second. The interface to it is provided by F… Read more Sqlite3 Disk I/o Error Encountered After A While, But Worked After Using Copy Of Db

I am trying to display the raw data from a varbinary field in SQL server in php. I want to return … Read more Php With Mssql Display Raw Data From Varbinary Field

According to the Flaskr tutorial, db connection should be opened and closed before each session: @a… Read more Flask Before_request And Teardown_request For Db Connections

I looking for an solutions on 'How to get auto increment id by PDO before execute', is ther… Read more How To Get Auto Increment Id By Pdo Before Execute

In SQL Server Management Studio when creating a New Table or adding columns to an existing table th… Read more How Do I Set The Allow Nulls Property In Table Designer Of Ssms To Be Always False?

I have strange issue in my win-form application where I am calling a stored procedure and it takes … Read more Sql Stored Procedure Execution Time Difference

I have a folder with more than 300 Access databases (written by a program over which I have no cont… Read more How To Import Multiple Access Databases Into Sql Server Using Ssis

Well this i did the below to get the error, don't have a clue why the database connection fails… Read more Unable To Open The Physical File Operating System Error 32

I have the follow hibernate code, session.createQuery('from Car as car where car.keywordName li… Read more Hibernate Using In And Like Clause Together

I am getting the 'interval' wise (30 min, 15 min, 45 min) data in my stored procedure now I… Read more I Want Combine My Time Slots As Per Interval (15,30,,45,60) And Do The Additon Of Columns In Sql Stored Procedure

Is it possible to reuse an identity field value after deleting rows in SQL Server 2008 Express? Her… Read more Reuse Identity Value After Deleting Rows

Below is the SQL Query I used to create as view CREATE VIEW [v_AMP_C] AS SELECT dbo.IC_R… Read more After 13th Row Dynamic And In 12th Row Static Values With A Formula

Basically I'd like to get this command to work: $sql = 'SELECT (EntryDate + TotalTime) as D… Read more Using Cast In Sql With Multiple Column Selections

Problem: Identify all SSIS packages that connect to a specific database table on SQL Server. Detai… Read more How To Query Integration Services Catalog

I want to restrict non-owners (excluding sys dba) from accessing the table i.e. users can access on… Read more How To Write A Policy In Oracle Sql That Restricts The Access To Non-owners For A Table?

I have 3 tables: tbl_indicator grp_nbr, sect_nbr, indicat 1 100 p 2 … Read more Sql Update (help Me )

I have an .ps1 script grabbing applications under each app pool as follows param([string]$appPool) … Read more Storing Results From Powershell To Sql Table

I have the following PHP code: $testMessage = 'TESTMESSAGE'; $db = new SQLite3('messag… Read more Php Sqlite Json Data Duplication

If list LL: LL = ['foo', bar', 'noo', 'boo',] is in a MySQL table, tes… Read more Delete Multiple Rows In Mysql With Info From Python List

I am working on a C# MVC application. In this application user is uploading data from EXCEL spreads… Read more How To Save Bulk Records As Transaction To Sql Server More Efficiently?

The build is success but when it comes to this method, it throws exception. This happened when I up… Read more Xamarin Form Sqlite Connection : Method Not Found: Int Sqlite.sqliteconnection.createtable(sqlite.createflags)

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.D… Read more I Can't Find Columns Of Database

Given some data in BigQuery in the following format: | id | r.key | r.value | +----+-------+-------… Read more Convert Bigquery Data From Key-value To Columns

I have this function in plpgsql: CREATE OR REPLACE function login_v(em varchar, passwd varchar) R… Read more Demonstrate Sql Injection In Pl/pgsql

I'm trying to update a value of document created on cosmosDB azure using sql api. The problem i… Read more Update Cosmosdb Azure Sql

Tried searching around with no luck, maybe I'm just not using right the terminology. Anyway, I&… Read more Assigning A Visit Number To Rows In A Database?

First of all: everything you will read in this post happens only if Windows 10 April 2018 update is… Read more Sqlconnection Error If Exe Is Executed From Network Path

Today I created a new table in SQL Azure portal and by default there is an Id INT column. Id ( int … Read more Sql Azure - Could Not Able To Alter Column Type

This is the code I' using for reading data from sql through DataReader. It gives Error when the… Read more Handle Null In Datareader

Here is my sql query i want to convert it into lambda expression Select P.PlaceName As UnitNumber,… Read more Convert Sql Query Into Lambda Expression

My question has to do with the order of updates in a single update statement. I have observed that … Read more Updating Column Based On Another Updated Column