Lab Sql

I open one database at the start, then need to open another database based on user selecting two va… Read more Change Sql Server Connection String Dynamically Inside An Asp.net Core Application

My simplified and contrived example is the following:- Lets say that I want to measure and store th… Read more What Is The Best Way To Store Historical Data In Sql Server 2005/2008?

I have a table with int values being used as bitfields (where each bit is a flag). Now I would like… Read more Aggregate Bitfield Values With Binary Or

I have the following query method in my ActiveRecord model: def self.tagged_with( string ) arra… Read more Rails: Has Many Through Associations -- Find With And Condition, Not Or Condition

Please consider the following SQL Server table and stored procedure. create table customers(cusnum… Read more Can You Call A Sql Stored Procedure That Returns A Record Set And Have Those Values Loaded Into Variables?

Recently, I've been asked to write a query to select properties of entities from a group that c… Read more Which Sql Query Is Faster And Why?

After a good dose of Googling and trying some things and not finding/getting the desired result I d… Read more Passing An Icomparer Parameter To Custom Linq Orderby Extension Method

Having deployed a new build of an ASP.NET site in a production environment, I am logging dozens of … Read more Sporadic Asp.net Data Error: "cannot Find Table 0"

I have a table with Employee Type Codes and I am trying to return all the Users that do not have a … Read more Sql Query User Has One Record In The Table But Not Another One

I have a table of lists and a table of list items. I want to formulate a query to select just one l… Read more How To Select Just 1 Child Table Item For Each Parent Record?

Possible Duplicate: how to sync SQLite database on android phone with MySQL database on server? I… Read more Sync Databases Mysql Sqlite

I use Oracle 11g. My data file looks like below: 1|'\a\ab\'|'do not 'clean' ne… Read more Sqlldr- No Terminator Found After Terminated And Enclosed Field

I am writing a query that is supposed to give me a count() and three avg()'s. The count() works… Read more Sql Avg() Returning The Wrong Result For 3 Columns

How do I INNER JOIN a table that contains 2 foreign keys as its primary keys? CREATE TABLE table1 (… Read more Joining Tables With Foreign Keys

I have a query like below. SELECT occupation AS 'Contact occupation', sum(total) AS 'Qu… Read more How To Read From The Two Same Dates Without Input The Time

I am new to EF6 and I have set up the Chinook database and gotten it working with SqlLite .NET prov… Read more Linq Query Returns The Same Names Even Though They Should Be Different

Hello, i have the following code in SQL Server, why if i want to calculate the sTArea of @geog fa… Read more Convert Geography To Geometry Sql Server 2008r2

I have a query which works fine and delivers the result SELECT PartyName, Risk, SUM(CAST(Amount AS … Read more Select Top(10) With Nested Group By

I am querying data from two tables (students2014 and notes2014) in order to return a list of studen… Read more Returning Only Latest Result From Left Join

I have the following scenario involving 2 classes: public class Parent { [Key] public int Id {g… Read more Cascade Update In Entity Framework