Skip to content Skip to sidebar Skip to footer
Showing posts from January, 2024

Insert Into Postgresql

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

How To Mimick Oracle Materialized Views On Ms Sql Server?

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?

Order By Year, Month Along With Cumulative Sum

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

Adventureworks2012 Db - How The Password Was Stored And How The Password Validated?

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?

Oracle To Derby - Connectby And Start With Equivalent In Derby

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

Can't Compare Dates Using Sqlite With Ef6

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

Find The Elapsed Time Between Two Dates In Oracle Sql

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

Problems With The Execution Of A Sp In 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

Linq: Adding Where Clause Only When A Value Is Not Null

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

"object Was Open" Error Using Delphi, Sql Server And Ado

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

Join Two Tables Based On Two Columns

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

Android : How Can I Retrieve My Desire Data In My Database

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

Find Json Schema In Sql Server

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

Real Time Sync From Sharepoint To 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

Data Driven Subscriptions Ssrs Standard Edition 2008

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

How To Use Limit Keyword In Sql Server 2005?

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?

Ssis Conditional Split, But Want To Check A Pattern

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

Using Database And Dict To Add Menus And Triggers

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

Query To Identify Contiguous Ranges

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

Trigger On Update Firebird

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

Which Values Are Making The Conversion From Varchar To Date Fail?

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?

Create One Trigger For Multiple Operations

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

Different Result Query When Use Mysql And Mariadb

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

Synchronize Data In Two Database Table Upon Deletion

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

Why Sql Server Image In Binary Causes Issue In String Query But Works In Parameterized Query

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

Other Solution Instead Of Cursoring

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

Mysql, Polish Characters And Duplicate Insert Statement

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

Constructing A Temporary Table In Oracle Sql

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

Problem Constructing Where Clause To Include Null/0 Values

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

Using Left Join To Only Selection One Joined Row

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

Windows Firewall Rules For Sql Management Studio

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

Merge Tables With Postgresql

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

Using Raw Value-expressions In Update With Jooq

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

Sqlalchemy Duplicated Where Clause To From

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

Sqlalchemy Raw Sql Vs Expression Language Statements

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

Importing New Database Table

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

Find Polygon Overlaps

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

Sql Subselect Filtering Based On Multiple Sub-rows

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

What Does "resetting The Connection" Mean? System.data.sqlclient.sqlexception (0x80131904)

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)

Sqlite3 Disk I/o Error Encountered After A While, But Worked After Using Copy Of Db

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

Php With Mssql Display Raw Data From Varbinary Field

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

Flask Before_request And Teardown_request For Db Connections

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

How To Get Auto Increment Id By Pdo Before Execute

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

How Do I Set The Allow Nulls Property In Table Designer Of Ssms To Be Always False?

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?

Sql Stored Procedure Execution Time Difference

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

How To Import Multiple Access Databases Into Sql Server Using Ssis

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

Unable To Open The Physical File Operating System Error 32

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

Hibernate Using In And Like Clause Together

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 Want Combine My Time Slots As Per Interval (15,30,,45,60) And Do The Additon Of Columns In Sql Stored Procedure

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

Reuse Identity Value After Deleting Rows

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

After 13th Row Dynamic And In 12th Row Static Values With A Formula

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

Using Cast In Sql With Multiple Column Selections

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

How To Query Integration Services Catalog

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

How To Write A Policy In Oracle Sql That Restricts The Access To Non-owners For A Table?

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?

Sql Update (help Me )

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

Storing Results From Powershell To Sql Table

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

Php Sqlite Json Data Duplication

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

Delete Multiple Rows In Mysql With Info From Python List

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

How To Save Bulk Records As Transaction To Sql Server More Efficiently?

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?

Xamarin Form Sqlite Connection : Method Not Found: Int Sqlite.sqliteconnection.createtable(sqlite.createflags)

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)

I Can't Find Columns Of Database

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

Convert Bigquery Data From Key-value To Columns

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

Demonstrate Sql Injection In Pl/pgsql

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

Update Cosmosdb Azure Sql

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

Assigning A Visit Number To Rows In A Database?

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?

Sqlconnection Error If Exe Is Executed From Network Path

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

Sql Azure - Could Not Able To Alter Column Type

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

Handle Null In Datareader

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

Convert Sql Query Into Lambda Expression

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

Updating Column Based On Another Updated Column

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