comprasconencanto1

I have a data set that I need to filter a date that is stored as a string (changing the source colu… Read more I Still Get A "arithmetic Overflow" When I Filter On A Cast Datetime Even If I Use Isdate()

I have a question. I am working on cursors. Each time, after fetching the last records and printing… Read more Solving A Problem With Cursors

I have the following mapping (straight from SA examples): class User(Base): __tablename__ = … Read more Sqlalchemy Session.refresh Does Not Refresh Object

I would like to do this kind of thing: IF ((19, 13) NOT IN (select idUtente, IdLezione from partec… Read more If In Mysql Insert Statement

So I am trying to create a Probability Density Function from data in an Oracle SQL table through a … Read more Oracle Sql Create Pdf From Data

Here is my table structure: // posts +----+-----------+---------------------+-------------+ | id | … Read more Isn't Using Unnormalized Design Better When There Are Multiple Joins?

OK this will probably be a lot of explanation for a small question, so here goes. I have a quiz sys… Read more Multiple Requests To Php Blocked By First Connection

I have a temporal table Employee with EmployeeHistory as its history table. In C#, I am using SqlCo… Read more C# Sqlconnection Querying Temporal Tables

I installed a x86/x64 official SQLite NuGet package on Visual Studio 2010 by following these instru… Read more Sqlite Database File Type Missing From Visual Studio 2010 Data Source Options

I am trying to sort some Nagios alerts in MySQL. I would like column 2 to be grouped together as it… Read more Mysql Order By Category And Subcategory

I have created a mdf database from visual studio 2013 and stored some informations in the table. My… Read more Connect Local Database Mdf Visual Studio

I have database like: id | identifier | status | content --------------------------------------- … Read more How To Fetch 20 Continue Number Row In Postgresql

I'm trying to pass an array of string as a parameter to my query but I get the following error … Read more How To Using Like Array Of String Hibernate

I have a stored procedure like this: ALTER PROCEDURE [dbo].[T_TransactionSummary] @locations nva… Read more Stored Procedure Always Taking First Parameter From The Code

So I have a in-memory database and I'm trying to insert data into the table and it's not wo… Read more Insert Data Into Sqlite In-memory Database

I created a user profile where users can add their information. So on URL section I want them to pu… Read more Cakephp Associations Error? Won't Save Associated Table

Let's say I have a this search query like this: SELECT COUNT(id), date(created_at) FROM entries… Read more Get Count Of Created Entries For Each Day

I'm trying to get my data files (of which there are a dozen or so) into tables within SQLite. … Read more Sqlite3 Import Csv & Exclude/skip Header

I have tables A, B, C. Table A is linked to B, and table A is linked to C. I want to join the 3 tab… Read more How Can I Join 3 Tables And Calculate The Correct Sum Of Fields From 2 Tables, Without Duplicate Rows?

Hi i am trying to insert the values in to mysql table. i am trying this code. i have assigned value… Read more How To Use Java Variable To Insert Values To Mysql Table?

I need a help with SQL SELECT query. I have [Details] sql table below. I want to select rows that … Read more Tsql - Excluding The Rows That Matches With Temp Table

I've been battling with this problem for a week now and I need help. I have a select statement … Read more Select The Max And Second Max Value From A Select, And Group Them?

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

Is there a way to include a LIKE expression in a GROUP BY query? For example: SELECT Count(*) F… Read more T-sql - Group By With Like - Is This Possible?

I have an old PHP application with a bunch of MySQL tables. I want to rewrite it with Rails(3) and … Read more Import Mysql-db-dump Into A Rails App Using A Migration File

Is this the good way to do file locking with re-entrance in a context manager under Python 2.7? I j… Read more Sqlite3 Context Manager With File Locking In Python 2.7

I would like to understand how MariaDB administrates temporary tables. For example, how MariaDB cop… Read more How Mariadb Administrates Temporary Tables?

Example: I have some articles and comments and I want to get something like this: [{ title: '… Read more Construct Nested Object Graph From Sql Hasmany Relationship

is it possible to execute a dynamic piece of sql within plsql and return the results into a sys_ref… Read more Executing A Dynamic Sql Statement Into A Sys_refcursor

Fairly simple question, but seems impossibe to get an answer. If I have this: declare @Agent nvarc… Read more Split String Via Select Statement

I have a datareader that return a lsit of records from a sql server database. I have a field in the… Read more How To Check If A Datareader Is Null Or Empty

First of all we are just migrating from SQL Server to Mongodb. I have a collection containing field… Read more Max And Group By In Mongodb

I have an SQL query that I am testing, and running as below, but I noticed that it seemed to be ret… Read more Sql Update, Same Query, Different Results Each Time

Viewing the Execution plan, i see 'column A' in the Output List. The operation is an Index … Read more How Can A Non-clustered Index Output A Column That Is Not Included In The Index

So I have this column called MESSAGE on my LOGS Table that has every line starting like this (well,… Read more Extract String From Column Sql?

I should probably be able to find an answer to this but my Google-fu is weak today. When I have th… Read more Sql Server Stored Procedures: Do They Queue Up?

please help me with my format query in laravel 5. I am a beginner in using laravel 5, and i just se… Read more Laravel 5 Inner Join And Group By Query Syntax Error

Suppose I have a table with 2 fields: Number and Description, I want to get the description from a … Read more How To Write A Range Query In Sqlite Android?

I am trying to retrieve the last record inserted/updated in the table SHIPMENT_EVENT. There are a c… Read more Need To Retrieve Table's Last Inserted/updated Record With Some Exclusions

In my previous question, I managed to get the rank of a table based on its value in that table. I c… Read more Sqlalchemy Only Func.rank() Rows In Table Where Value = X

I have updated SQL Server Management Studio to the latest version at time of writing - 12.0.4432.0 … Read more Sql Server Management Studio 2014: Unable To View Stored Procedures On Azure Sql Database V12

I this is my first attempt to create procedure and execute it. First I create simple table. DB sche… Read more Problem With Execute Procedure In Pl/sql Developer

i have the following DB-Structure / hierarchy: TABLE product_type: id,name, .... TABLE product: id… Read more Mysql: Join Many Tables On One Statement

My Scenario is - I have one set of data in .xls file and another set of data in oracle data base ta… Read more How To Join Two Recordset Created From Two Different Data Source In Excel Vba

I am creating filters in my HTML table binded with asp.net web API using HTTP POST request and usin… Read more Dynamically Build A Sql Where Clause From C# Objects

Let's say I have two tables of books and two tables of their corresponding editions. I have a q… Read more How Can I Exclude Left Joined Tables From Top In Sql Server?

If I have a table of data as such name | type | count test | blue | 6 test2 | red … Read more Postgres Simple 'pivot' Table

I got following code. The problem is I could read data use panda.read_sql, but I could not use the … Read more Pandas To Sql Server

I have view for which it only makes sense to use a certain ordering. What I would like to do is to … Read more Does Order By In View Guarantee Order Of Select?

I cannot find an appropriate connection string to a Microsoft SQL server, it's the 2014 develop… Read more Microsoft Sql Server 2014 Over Network. Oledb Connection String

I have an sqlce 3.5 local db file in my VS2010 solution used with an EF4 Model. I need to protect m… Read more Sql Ce 3.5 & Entityframework

I'm hashing a password in SQL directly like this : DECLARE @HashThis nvarchar(4000); SET @HashT… Read more Hashing Password Into Sql

I have a table which looks like this: NAME Col1 Col2 Col3 Tim 1 2 3 Tim … Read more Oracle Select Distinct Return Many Columns And Where