Lab Sql

I am trying to create a trigger to write logs when rows in x table have been edited. This is the cu… Read more Using Concat With Mysql Triggers (error At ,)

I have a table in which vehicle mileage i.e the mileage of the vehicle is stored on a regular basis… Read more Calculate Mileage Of Vehicles By Subtracting From Vehicle Readings

My servlet function looks like these: CODE: protected void doGet(HttpServletRequest reques… Read more Class Notfound Exception In Sqlserver Connection In Eclipse

My app requires data from a sqlite database. It will ship with a version of this database, but I n… Read more Updating Sqlite Database Without Xml

i have a table which contains user_rights on folders. Considering that rights are inherited on fold… Read more Oracle Hierarchical Query Start Clause From Join

If I have an SQL query like this one: SELECT playerno,town FROM players GROUP BY town In this case… Read more Which Record Will Group By Choose In Sql

I have a Query using T-SQL MERGE Statement. Due to performance issues I am re writing the Query usi… Read more Merge Statement Delete Alternative In Sql Server

I have a SQLite database that has a single table with 18 million rows and 24 columns. I have writte… Read more C# Outofmemory Exception When Returning A Small Datatable

Is it possible to make a mysql query returning values without default order.for example am using th… Read more Mysql Query To Return Results In Specific Order Without Order By

I have a table which is attached in image here sample table values I want that this conditions will… Read more How To Use Between Clause On A Nvarchar?

I am creating an app in which I have executing an select to get the access rights an base on the ri… Read more Getting Sqlitelog (23) Not Authorized Error While Select Query In Phonegap Android.....

I'm using UNION ALL to combine the results of several SELECT queries into one ResultSet. I use … Read more What Syntax Is Used To Select A Constant Field Value From A Javadb Database?

I have three A, B, C tables. How can I join A with B and also B with C at one time? For example If … Read more How Can I Join A With B And Also B With C At One Time?

The SQLite database is not created. I am playing with this for the past few hours but now i got tir… Read more Android Sqlite Database Is Not Created

I have the following data: ID CLASS VALUE 1 NHB 700905.7243 1 HBW 164216.1311 1 HBO… Read more Postgresql Says "return And Sql Tuple Descriptions Are Incompatible"

I am using sqlite in a C++ project and I would like to be able to get the table names involved in a… Read more Sqlite3 C/c++, Get The Table Names Involved Int An Aggregate Query

While using ADO.NET (maybe i am wrong, i dont know what its called) i notice that i can only begin … Read more Sqlite Only Supports 1 Transaction?

I have the following scemantic. An alert can have a status change and only one. A status change can… Read more Does Sqlalchemy Really Have One To One Relationships

I have a ViewModel and I currently return a query where if the movie has employees and they have a … Read more Adding Additional Query To Return(view)

I just want a quick way (and preferably not using a while loop)of createing a table of every date b… Read more How To Get A Table Of Dates Between X And Y In Sql Server 2005

I am looking to identify return visitors to a website within a 7 day window. A data sample and atte… Read more Postgresql: Identifying Return Visitors Based On Date - Joins Or Window Functions?

I have the following EF Code First classes, which appear to be working to a point. I also have Ini… Read more Reinstantiating Ef Classes With One-to-many Relationship And Compound Key Of Strings

I have a SQL CLR function which at the moment returns a string seperated by a comma. How would I co… Read more Sql Clr Return Two New Columns