summer2012training

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 am trying to map a TimeSpan Code First property to SQL server. Code First seems to be creating it… Read more How Do I Map Timespan With Greater Than 24 Hours To Sql Server Code First?

How can I see the structure of table in SQLite as desc was in Oracle? Solution 1: PRAGMA table_inf… Read more How Can One See The Structure Of A Table In Sqlite?

I'm getting some issues while trying to export a query to CSV using the COPY function. The COPY… Read more Copy Csv Using Custom Filename Path

I am working on a website with a menu structure so that it can read submenus from multiple table be… Read more How To Create Hierarchical Menu From Different Table Based On Sample Database Structure

I'm using TransactionScope to make a method that contains multiple sql statements transactional… Read more Transactionscope And Method Call That Uses The Same Connection

I am trying to query a sql lite database with only an offset and no limit. SELECT [Id], [Name], [In… Read more Sqlite With Skip (offset) Only (not Limit)

I want to drop a now supposedly redundant file in SQL Server (2005), but when I try to drop it I am… Read more How Do I Find Out What Tables Have Data In A File In Sql Server?

Dear nerds and forumianers, I have a delicious problem with PHP on a Oracle database with ODBC driv… Read more Php, Oracle And Odbc: How To Check If Result Set Is Empty?

In MySQL it is possible to limit the number of records affected by an update query. In an ideal wor… Read more Sqlalchemy: Update... Limit 1, Not Possible?

Can somebody please tell me which is the better way, they both produce the same results but which i… Read more Which Query Is The Correct Way?

I have a table Cars as follows: This table will be read in grid of a C# application. The applicati… Read more Insert Or Update Datatable Values Into A Database Table Using Stored Procedure

I've 16 queries that I need to execute. All these queries have the same format : SELECT string… Read more Sql Server: Multiple Queries Or Union

I need to execute the next query with symfony : $qb = $this->_em; $query = $qb->createQuery( … Read more Symfony Createquery With Union

I have been struggling with SQL statement when converted to VBA. Basically, I wish to add something… Read more Select Query Does Not Work When Converted To Vba - Invalid Sql Statement

After several tries, I was able to generate a row_number() column with the value I wished. select &… Read more Sqlite - Update Column Of The Same Table, Based On Result From Row_number()

I have a customer table, and a detail table. I want to want to pull a record for every customer in … Read more Sql Left Join: Selecting The Last Records In A One-to-many Relationship

This is the follow up question of : Prepare a recursive query I have the table with the two columns… Read more Sql Server 2008 R2: Recursive Query

I am getting the following error while running my joomla xmlImport.php file. SQLSTATE[42000]: Synta… Read more Sqlstate[42000] Syntax Error Or Access Violation Row Size Too Large

I have a from that a user fills in and their data is stored in a row using SQLite, a cursor gets t… Read more Sqlite Updating A Row And Updating Listview Created By Cursor

I'm getting crazy for what I believe it is a really silly matter. I need to render the result o… Read more Odoo Qweb Report Lines In Alphabetical Order

I want to select all Id from a table that have rows for both programs 'basketball' and '… Read more How To Select Id's That Have Rows For All Values From A Set

Is there any performance related features between createNamedNativeQuery and createNativeQuery, bec… Read more Performance Createnamednativequerie Vs Createnativequery

How in SQL could you 'zip' together records in separate tables (à la the UNIX paste(1) util… Read more Paste(1) In Sql

From a fresh project, I tried to rename the 'users' table to 'app.users'. I manage… Read more Laravel Sql Issue On 5.5 Auth Validation

I have a scenario where there may exist multiple DML statements inside my PLSQL Block, I was lookin… Read more How Can I Calculate Aggregate Affected Rows If There Are Multiple Dml Query In My Plsql Block?

I'm reading TSQL code someone else wrote and find a somewhat weird syntax. It's doing order… Read more Sql Server Order By Syntax With Case When And A Constant

This query works great in SQL Server 2005 and 2008. How would I write it in SQL Server 2000? UPDAT… Read more Sql Server 2000 Top And Output Keywords

this is the table id value name 1 2 first 2 2 manger 3 2 islam 4 2 … Read more Convert Rows To Columns With Some Conditions

I simply try to open a database in READWRITE Mode. I get the following error: 'not an error (co… Read more Open Database For Readwirte Not Possible On Specific Device

How can I query a table that looks like this: DECLARE @test as table ( [Id] int, [Changes] … Read more Tsql Split Xml Nodes

My application fails to start. It consists of Spring Boot + JPA + SQLite. But Spring Boot and MySQL… Read more Bean Named 'entitymanagerfactory' Could Not Be Found

I have a SELECT statement being calculated from a CASE WHEN THEN state (or could use multiple IF st… Read more Can You Group By With A Case When Then Alias Name?

Let's say I have a table Employee like this EmpID, EmpName 1 , hatem and I write a query: … Read more How To Export Xml Using A Sql Server Query?

How can I have a var which contains all the records I get from a resultset? So far I have this code… Read more Troubles Getting Results From Resultset

Can i create an oracle 'View' with a DB generated Primary Key? I want to create a view wit… Read more Oracle View Creation With A Database Generated Id From A Sequence Object

Hello guys I'm new to this, I need your help to fetch users who are not yet friends. This is my… Read more Mysql Fetch Users Who Are Not Yet Friends

I'm trying to load a .csv file with baseball schedules into a table of games. The csv file cont… Read more Mysql .csv Load Failing Due To "cannot Add Or Update A Child Row: Foreign Key Constraint Fails"

I have a table with a column which contains strings like below. sourabh@winworldsoft.com monica@win… Read more Fetching The Sub-string From The Database