Spark Sql Blog

Got sql to pad 0's from: Formatting Numbers by padding with leading zeros in SQL Server What I… Read more Pad 0's To Returned Query And Insert Into Temp Table

I want to see what customers ordered what from a given manufacture. I have theses tables (with colu… Read more How To Join Multiple Tables In Mysql?

Description I am learning Flask and I created a database which contains 3 tables which are related … Read more How To Loop Through Related Tables With Jinja2?

If I wish to simply rename a column (not change its type or constraints, just its name) in an SQL d… Read more How Do I Rename A Column In A Database Table Using Sql?

We have a field that contains HTML markup for formatting on the website, but we need to query just … Read more How Do I Query A Database Field But Ignore The Html Markup?

I want to create a function that returns multiple rows into a table that is of object type. I have… Read more Return Multiple Values From Oracle Function

I have a table in Hive, which is generated by reading from a Sequence File in my HDFS. Those sequen… Read more Hivesql Access Json-array Values

Please forgive me if this is a basic question, I'm a beginner in SQL and need some help perform… Read more How To Perform Date Calculations From Different Tables?

Before I run off and write my own version from scratch, is there an API that exposes the system vie… Read more Is There A C# Api For Sys.tables And Sys.procedures?

I am making a test. I have all tests in rows, so my rows looks like this; ID | TEST -------------… Read more Explain For In Oracle

I'm trying to create relationships with my tables in SQLite (I'm currently working with Xam… Read more How To Create Relationships With Sqlite (foreign Key)

I am new in using File Explorer in eclipse as well as Android. I have created a database using SQL… Read more Android: Can't Find My Package Folder To Put The Database File In It?

I need to write a query that returns the latest message in a conversation between two users. I'… Read more How To Get The Latest Message In Each Conversation Of A Certain User In Sql?

Im developing small size MFC VC++ app. For that i need to integrate Sqlite3 with existing MFC app. … Read more Integrating Sqlite3 With Mfc Vs2012

is it possible to somehow use function register_composite from psycopg2, when i am using sqlalchemy… Read more Psycopg2 Register_composite From Sqlalchemy

We have our main database on a server, there is this stored procedure; when we run it against the d… Read more Same Query, Same Database, Different Server, Different Result

I have tried the following query in Microsoft SQL Server Management Studio: select ROW_NUMBER()… Read more Row_number() In A View In Sql Server 2005

so I want to make an app that lists foods that I have stored in an already existing SQLite database… Read more How To Populate Listview With Db In Asset Folder?

I have written an SSIS package to create a Fuzzy Grouping. I can run it from Visual Studio targetin… Read more Why Can I Run Ssis Fuzzy Grouping From Visual Studio But Not The Deployed Package?

I have a query that looks at one tables field and matches the second table's field. It looks to… Read more How To Compare Fields With Null Values In Access

I am looking for creating a SQL view where I have data as per the below screenshot I want to conve… Read more Iterate Within View In Sql Server

I have a table with all entries for employees. I need to get all the working hours and the entry an… Read more Get Users Attendance Entry And Exit In One Row Sql Server

for _item in file_list: for col in cursor.execute('select column1,column2 from tbl'): … Read more Function Sequence Error (0) (sqlfetch) - Sql, Pyodbc

I have the following code in my C# code-behind page to execute on button press: String cString; … Read more Why The Sql Command Is Not Executing

EDIT: Here is a more complete set of code that shows exactly what's going on per the answer be… Read more Writing Efficient Queries In Sas Using Proc Sql With Teradata

I have a database in which a table has name Registration which is used to register the user. It ha… Read more How To Insert Row In Sql Database In Ado.net Connection Oriented Mode

I have a fairly large SQL Query that converts a numeric date data type to a date time value and fur… Read more Output Of Empty Columns In Sql Query

I want to grant a user permission to create, alter, and execute stored procedures, but without the … Read more Sql Server 2005 - Granting Permission To Create Stored Procedures (but No Other Objects)

I am working on a project which uses a relational database (SQL Server 2008). The local (on-premise… Read more Is It Possible To Run Sql Express Within A Azure Web Role?

I'm trying to update my local android app database data , I used the update query: public void … Read more Updating Sql Table Data In Android Applcation

I have a table containing the below test data: I now would like to fill a restaurant with 12 seati… Read more T-sql Loop Through All Rows And Sum Amount From Column Until Value Is Reached

Let's say I have a database table with several common columns such as name, gender, age, ... Be… Read more Select From ... - Based On A Value In Json Format

The highlights in the image below shows the logic I want to implement. I realize the syntax is inco… Read more Merge - Conditional "when Matched Then Update"

I am trying to write a view where one of the column is a business logic which is like a SLA time di… Read more Write Oracle Db View Based On Different Column Time Stamp Difference

I am trying to return the results of a stored procedure to a form. I have managed to iterate thru t… Read more Bind Access Form To The Results From A Stored Procedure

Sl,No Name BirthDay 1 Jojin1 2013-05-12 00:00:00.000 2 jojin2 2012-06-12 00:0… Read more How To Use Convert Function In Sql Server?

In OrientDB I have setup a time series using this use case. However, instead of appending my Vertex… Read more Orientdb Time Span Search Query

I am creating After Insert trigger , its working fine, but I have certain conditions before executi… Read more Sql Trigger After Insert Update Another Table With Conditions

I have session lock procedure which do the action of when one procedure is running in one session i… Read more How To Execute A Stored Procedure With Another Stored Procedure?

I have a large *.csv file that I would like to query using SQLlite and dplyr verbs in R. How can I … Read more Setting Up An Sqllite Database In R From A Csv File That Cannot Read Into Memory

Hi friends I have 3 table topups, withdraws and transfers these 3 tables belongs to the user table.… Read more How To Join Multiple Tables In Sql

I have 2 tables, one is called Food while the other is FoodCategory. The relation between them is t… Read more Ms Sql Query Within A Query Coldfusion Environment

Does the documentation quotation from this answer: https://stackoverflow.com/a/542691/1011724 When… Read more Does Linq2sql Automatically Put Executecommand In A Transaction

I am getting an error when creating a foreign key. The error is 1822 and it says the following: Er… Read more Getting Error 1822 In Mysql When Trying To Create A Foreign Key

Trying to do what a SQL query (SELECT DISTINCT (first,second),third FROM table) would do but I am d… Read more Distinct On Multiple Columns In Datatable

I'm using SQL Server 2008 R2 and trying to use transactions. First a question about transaction… Read more Nested Transaction Scope .net

Looking to throw an error where the value i'm updating is a 'not null' value. For examp… Read more In Sql How Do I Throw An Error When Updating 'not Null' Values In A Database Table

I have a multi-threaded Linux C++ application that needs a high performance reference data lookup f… Read more Can I Achieve Scalable Multi-threaded Access To An In-memory Sqlite Database

I want to get the callback of a successful SQLite transaction with Ionic 2. I am still currently le… Read more Ionic 2 Sqlite Manage Callback With Promise

How can I open a *.mdf file of a database created with Visual Studio 2010, into SQL Server Manageme… Read more Attach (open) Mdf File Database With Sql Server Management Studio

I'm trying to use Entity Framework Tracing Provider to log the SQL staments generated. I change… Read more Logging Sql Statements Of Entity Framework 5 For Database-first Aproach

I have a query which displays information from a table like this. SELECT tag.label, inputs.input_ra… Read more Sql Runtime Reports

I wonder that do i follow correct approach and need your help to figure out Here my non-protected q… Read more Preventing Conditional Insert/update Race Condition In Ms-sql

I have two tables ACADEMIE: CREATE TABLE [dbo].[R_ACADEMIE]( [ID_ACADEMIE] [dbo].[IDENTIFIANT] … Read more Conflict With The Foreign Key Constraint

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'm using Entity Framework 5 to connect to SQL Server 2008. I've imported a stored procedur… Read more Entitycommandexecutionexception Timeout Expired Only Sometimes

| uId | title | amount | makers | widgets | 1 richard 998 xcorp spr… Read more Postgresql: Top N Entries Per Item In Same Table

I need to get the string between the - and the ·, which is the GigabitEthernet1/0/1 CW-3D13-SW1 - G… Read more How To Get String Between Two Characters

I have a custom ExecuteListener that executes additional statements before the statement JOOQ is cu… Read more How To Safely Execute Custom Statements Within Jooq's `executelistener`?

I was surprised to encounter a SQL 2008 T-SQL proc that used a double quote as a string delimiter. … Read more Can Double Quotes Be Used To Delimit A String?

I am using MySQL v5.1.36 and I am trying to create a stored function using this code. DELIMITER // … Read more Errors With Mysql Stored Function Creation Error 1064 & 1327

using biml (via BIDS helper in visual studio) how do i assign values to the properties of the SSIS … Read more Assign Properties To Execute Package Task Ssis Object Using Biml

From Java I am doing the following query on DB2: SELECT * FROM PRV_PRE_ACTIVATION WHERE TRANSACTION… Read more Db2 Query Error During The Retrieval Of A Clob Field