Lab Sql

I need to update millions of rows as part of my next release, but doing so fills the transaction lo… Read more Update Query On Millions Of Rows Fills The Transaction Log

I need help running a stored procedure from SQL Server in PHP. PHP is running on a Unix/Linux serv… Read more SQL Server Stored Procedure Output Params In PHP

We have a Single Statement FUNCTION in SQL Server 2005 which uses CONTAINSTABLE(). All works fine w… Read more CONTAINSTABLE And CONTAINS, Which String To Pass To Match All Records?

I am getting error 'ORA-01428: argument '0' is out of range'. Subject in question i… Read more Getting Error "argument '0' Is Out Of Range"

I started by asking this question I wish to Select all rows which contain any element from an array… Read more How Can I Select All Rows Where Column Contain Any Words Of A String

I have a large XML file that I need to import and parse into tabular structure ('flatten') … Read more Importing And Parsing A Large XML File In SQL Server (when "normal" Methods Are Rather Slow)

Is it possible to attach multiple DBs to SQL CE 3.5 (Compact edition) e.g. MasterData.sdf, Orders.s… Read more SQL Compact 3.5 Attach Multiple DB/ Cross-db Query?

I have 2 tables - Sales and Product. Sales can store the product as Idn or Name (legacy design) and… Read more Why Does My Query Break When It Is Parameterized?

I have data which has missing time series values irregulaly for each users, and I'd like to con… Read more How To Fill Irregularly Missing Time-series Values With Linear Interepolation By Each User In BigQuery?

i am connecting to a mysql table through vba in excel and i am updating it: Set cn = New ADODB.Conn… Read more Connecting Excel To Mysql Update PROBLEM

Hello I have a simple question that regards inserting data into a MS MySql Database 2012 table. The… Read more C# List Items To Database SQL

i'm fairly new to programming. I am working with Xcode 6 and swift to build an iOS 8 app. my … Read more Using An Sqlite3 Database With An Ios8 App Using Xcode 6 And Swift

I am trying to create a table where the values in one column can't be greater than the next col… Read more The Values Of One Column Cannot Be Greater Than Another

I have some SQL queries that do not change on every request (only it's parameter). So, instead … Read more Is It Okay To Prepare SQL Statement Once For Multiple Request?

I'm trying to use wildcards for a query using SQLAlchemy but I'm getting back an empty list… Read more How To Use Wild Cards In SQLAlchemy?

The Background I was trying to solve the fourth realistic mission in hackthissite.org, and couldn&#… Read more Confusing SQL Error In SELECT NULL, *, NULL, NULL

I have written a CLR stored procedure to execute command passed to it as parameter. This is code fo… Read more CLR Stored Procedure To Execute Command

I'm working on a project where we are thinking of using SQLCacheDependency with SQL Server 2005… Read more Performance Questions For SQL Cache Dependency

i have following model: @Entity @Data public class Book { @Id @GeneratedValue(strategy = Ge… Read more Hibernate - Limit Size Of Nested Collection

I have the following query: select carBrand, carYear, carModel from cars; what I want is to get on… Read more How To Use DISTINCT When I Have Multiple Column In Sql Server

I want to run a query to bring back that occurred on or after a date where the input date is a time… Read more How Do I Compare Two Timestamps As Dates In SQL Server

What is the max size of a file that I can insert using varbinary(max) in SQL Server 2008 R2? I trie… Read more SQL Server 2008 R2 Varbinary Max Size

I am trying to implement a feature similar to the 'Related Questions' on Stackoverflow. How… Read more What Is The SQL Used To Do A Search Similar To "Related Questions" On Stackoverflow

We're still using old Classic ASP and want to log whenever a user does something in our applica… Read more Is It Better To Log To File Or Database?

I would like to calculate average in sql. I have following record in table. Let table name = frare… Read more How Can I Calculate Average With Condition In Sql

I have table with some fields that the value will be 1 0. This tables will be extremely large overt… Read more Is BIT Field Faster Than Int Field In SQL Server?

Consider I have *----*------*-----------*----------*----------*---------------*----------------* | … Read more How Do I Take Only Specified Required Columns From CSV File And Add Into A Table In Postgresql?

I am having issues with connecting Amazon AWS MySQL with SQLAlchemy. According to the instruction, … Read more ModuleNotFoundError: No Module Named 'MySQLdb' Amazon MySQL RDS 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