Lab Sql

I am trying to write a query to display the name of the project and the name of the parent project,… Read more Child + Parent Reference SQL

I have a query that is taking 9 minutes to run on PostgreSQL 9.0.0 on x86_64-unknown-linux-gnu, com… Read more Slow PostgreSQL Query In Production - Help Me Understand This Explain Analyze Output

I've got this query: SELECT year, month, week, C.cpg_pk … Read more Can I Use Oracle Analytical Function Here?

I found that the common way for scrolling forward through a result set is using sqlite3_step(): whi… Read more Sqlite Step Back

I have an asp.net application. In which i have this code: using (Data.connexion) { str… Read more Avoiding An Sql Injection Attack

I have a table which has multiple records of the same sales agent id but different sales amount. Ho… Read more Merge Multiple Records Into One Row In A Table

I have enabled CDC using the following steps: exec sys.sp_cdc_enable_db; exec sys.sp_cdc_enable_ta… Read more CDC Is Enabled, But Cdc.dbo_CT Table Is Not Being Populated

I want to insert a new item with a POST request in ORDS application express. I created my handler l… Read more How To Make A POST Request With ORDS?

I am using SQL Server 2005 Express and Visual Studio 2008. I have a database which has a table wi… Read more SQL Server: One Table With 400 Columns Or 40 Tables With 10 Columns?

I'm having a table with 3 columns: DATE_A, DATE_B and ISSUE DATE_A and DATE_B can be filled in … Read more Oracle 10g: Parsing 2 Columns Merging Duplicates

I'm using the following format for commiting changes to my db using linq. Begin Transaction (Sc… Read more LINQ + TransactionScope Will Not Change Isolation Level In SQL Server Profiler

I have to tables Tasks: id title Description Task_reply_mapping task_id parent_id I have writt… Read more Display One To Many Mapping Using Sql In Mybatis

I am trying to loop a varchar in SQL Server, one of the columns has the format 'F1 100 F2 400 F… Read more Is There Any Way To Loop A String In SQL Server?

I have a create table query, an update query ,and then drop table query. I need to run these three … Read more How To Run Multiple SQL Queries?

I want to group the query data based on the groupid attribute, the following image is my table imag… Read more Need To Get Data Grouped By Groupid

I have a script which creates a database, stored procs, views, tables, udf. I want to include a scr… Read more T-sql Create User And Grant Execute On Permission For Stored Procedures

Is it possible to pass a data from fragment to fragment by swipe? There are many articles teachin… Read more Pass Data To Another Fragment By Swipe View With Tab Android Studio,not Button

I am having an arraylist of strings. I needt to store that arraylist in the 1 column of database. … Read more How To Store The Contents Of An Arraylist In One Column Of Table In Sqlite Database In Android?

When running Bulk Insert BULK INSERT MyDatabase.dbo.MyTable FROM '\\Mylaptop\UniversalShare\S… Read more BULK INSERT Returns Error "Access Is Denied"

I need to use CTE query inside from clause of SQL Query See this example: Drop Table #Temp Drop Tab… Read more CTE In From Clause Of SQL Query