Lab Sql

This query always returns the same amount of rows but, in a different order, every time. Why does t… Read more Query Returns A Different Result Every Time It Is Run

I have 2 identical connection strings. One is for ASP.NET membership etc and the other is for every… Read more Why Does Only One Of These Connection Strings Work When They Are Actually Identical?

I'm using SQL Server's POWER function in a user function and when the base is a negative nu… Read more Error Using Power Function When The Base Is Negative And Exponent Is Fractional

I'm having class Report and class Program, what I want to accomplish (no luck so far) is to sen… Read more Saving Object To Database C#

I'm new to N1QL, and i'm trying to query an Inner Join for two different queries but I get… Read more N1ql - Query An Inner Join For Two Different Queries

I'm compiling a collection of store procedures in SQL Developer for the Mac. The code looks li… Read more Why Is This An Error : "encountered The Symbol "/" "?

I am trying to write an SQL (Server) query which will return all events on a current day, and for a… Read more Complicated Sql Server Query

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

Does Visual Studio SQL Server Data Tools (any version) support changing the default comparison mapp… Read more Visual Studio Sql Server Data Tools Comparison Mappings

I have a sample xml file created using Editplus( in windows). Solution 1: Considering your fir… Read more Xml To Oracle Db Table : Encountering Problems

This is my first post. help me. how to bind datatable to webgrid? My code: SqlConnection con = new… Read more How To Bind Datatable To Webgrid Using Mvc?

I'm trying to make a simple app with a database. The problem is that for some reason the app cr… Read more Database Causes App To Crash

I have a table that is populated using a foreach loop. One of my columns is SKU Group, which is a c… Read more Populate Dropdown Boxes While Also Populating Table

can someone explain to me why the variable expression in SSIS 2012 is at 4000 character limit? What… Read more Ssis Variable 4000 Character Limit And Spliting It Into Two Variables

I have a datetime field in my Postgresql, named 'dt'. I'd like to do something like SE… Read more Postgresql - Select Something Where Date = "01/01/11"

I am trying to use app.config file to load the connection string into the type provider but I am re… Read more Sql F# Type Provider, App.config, And Connectionstrings?

Newbie to SQL. Kindly help. I need to count number of records which have a pattern in one of the fi… Read more Using 'like' Operator With A Subquery That Returns Multiple Results

this is the table structure id empRef_ID mkt_route_ID sl_No ----------------------------… Read more Can I Use Pivot For This?

I would like to find the first 10 unused manual sequence numbers from a range. Please find my query… Read more Getting First 10 Unused Manual_sequence Numbers

I'm aware that the database engine itself is (often) on another machine and that SQL*Plus has n… Read more Can Sql*plus Read Environment Variables From The Machine Is It Running On?

I have read some arts about BCP or CLR code that will export BLOBs to individual files on the hard … Read more Sql Server 2008 R2: Best Way To Export Blob And Other Column Data Out To The File System

I'm trying to retrieve geography data from my SQl Server 2012 DB with: new SqlDataAdapter('… Read more One Of The Identified Items Was In An Invalid Format - Microsoft.sqlserver.type

I have the following SQL CASE statement that doesn't appear to be evaluating the conditional co… Read more How To Textually Indicate That There Are No Results In A Sql Select?

Seeing as Oracle has removed the JDBC-ODBC Bridge driver in the latest release of Java (version 8),… Read more Jdbc-odbc Bridge Removed In Java 8, What Is The Best Alternative?

In my current query: SELECT COUNT(WC.ID) AS 'Regions' FROM WHOLE_FEATURES_PDB_CHAINS AS WC… Read more Count Multiple Types Of Same Column

I have 3 Columns in db Time Parameter(00:15) , StartTime(09:00) , EndTime (15:00) Now I want to sho… Read more How Can I Show All Time Between 2 Different Time Parameter

I have working code that can select a few values from an XML file. The problem is that I have multi… Read more Xml To Sql - Selecting Multiple Nodes With The Same Name

I have a table in my database where I have about 100k clients and with a erroneous system that was … Read more Querying Database To Find Potential Duplicates Based On Multiple Columns

I'm having an inordinate amount of trouble using CTEs as arguments to a PostgreSQL function cal… Read more Postgresql Error: Subquery In From Cannot Refer To Other Relations Of Same Query Level

Edit: People are having a hard time understanding what i want. So here's pretty pictures that e… Read more Force Partial Join Order In Sql Server

in notepad++ SQL language it highlights the word 'type' in a blue color but in mysql reserv… Read more Is "type" A Reserved Word In Mysql

INGREDIENT(ingredient-id,name,price-ounce) RECIPE(recipe-id,name,country,time) USES(rid,iid,quantit… Read more Find The Names Of Recipes Where At Least 3 Oz. (quantity) Of Every Ingredient Are Used

In my CREATE VIEW I would like to: SELECT CONCAT( t.str1, t.str2 ) AS Title, CHAR_LENGTH( Title ) A… Read more Mysql: Select Concat Of Strings And Length Of Resulting Concat

Looking to store android.location.Address to a SQLite database. I am using ORMLite to persist my ob… Read more Android - How To Store Address To Db

I am trying to configure a simple DbHelper, and getting an error while executing. The error is: SQ… Read more Sqliteexception Near "null": Syntax Error: , While Compiling: Insert Or Replace Into

How to rewrite this: select tab1.id, tab2.id, tab3.id from tab1, tab2, tab3 where tab1.col1 = tab… Read more Oracle Join Operator

I am on a Centos 7 Linux machine trying to connect to an SQL database through pyodbc. I learned tha… Read more Pyodbc Can't Find Freetds Driver

I have this working perfectly with a ListView, but decided to update my code to use RecyclerView. I… Read more Displaying Data In A Recyclerview

I got some problems here, I can't make my find_by_sql request to render an ActiveRecord relatio… Read more Find_by_sql Renders An Array

Is there any way to compare two strings in SQL Server 2008 stored procedure like below? int returnv… Read more Comparing Two Strings In Sql Server

I Have created a procedure which has code like this: Create PROCEDURE Sample( @ID INT ) AS … Read more Error In Dynamic Sql Sp

I'm a noob to android. and I am getting an illegal argument exception when working with a SQLit… Read more How To Do I Resolve Illegalargumentexception?

I have a very large (2.5GB, 55 million node) XML file with the following format: A link Solution 1:… Read more How To Load Huge (but Simple) Hierarchical Xml File Into An Sql Table

I have the following tables: UserPrivileges: +--------+------+------+------+ | UserID | Col1 | Col… Read more Sql: Selecting Columns Based On Column Value From Another Table

I have a column in a table which I need to update. The column is computed like this: SELECT CASE WH… Read more Sql Update A Calculated Column

I want delete selected row in datagridview and also delete row in Mysql. private void deleteOrderBu… Read more Delete Selected Row In Datagridview And Also Delete Row In Database

Which is faster for millions of records: Permanent Table or Temp Tables? I have to use it only for … Read more Table Vs Temp Table Performance

First I create a simple table import threading from sqlalchemy import create_engine from sqlalchemy… Read more Sqlalchemy Connection Pool On Multiple Threads

In Oracle SQL I have a type: CREATE OR REPLACE type address_type AS OBJECT ( Street VARCHAR2(100), … Read more Calling A Pl Sql Function With Object Parameter In Java

I am trying to remove all the comments from a NVARCHAR value. I don't know which value I will g… Read more Remove All Comments From A Text In T-sql