Lab Sql

I have a requirement to load data from excel to Redshift. I am getting errors because there are nu… Read more Insert Into Redshift With Excel Vba

I have a table variable in SQL Server 2008 DECLARE @specsAndModel TABLE ( specName … Read more How To Execute A Sql String That References A Table Variable?

I am aware that this question repeats from time to time but I tried almost every response here and … Read more Database Login Failed For User

I have an MS Access table that has a many-to-one key to another one, and I would like a query to di… Read more Can Sql/access Display Foreign Key Rows As Columns?

I'm writing a SSIS package to output data from a SQL Server 2012 database to a .CSV file for a … Read more How To Return T-sql Query With Column Names As First Row

In my Laravel project, in the database table ads, I have the following structure : id | col1 | col… Read more Laravel - Randomly Select N Number Of Rows Containing Same Value In Certain Column After Applying 'order By'

When I try to join table A with B, I get only two rows - I do not get data for '55A' in Pro… Read more How To Join Two Tables And Replace Null In Second Table With Zero

I have a set of tables and am currently trying to set up the correct relationships for the tables. … Read more Resolve Cycles And Multiple Cascade Paths

Using Tsql, how can i know when Index rebuild, reorg or updatestatistics was last run on SQL server… Read more Tsql, Know When Index Rebuild, Reorg Or Updatestatistics Was Last Run On Sql Server

I am trying to write a trigger function in PostgreSQL 8.2 that will dynamically use TG_TABLE_NAME t… Read more How To Dynamically Use Tg_table_name In Postgresql 8.2?

Looking for a recommendation. I have a command line utility that now needs to process a large amou… Read more Recommendation For A Java In Memory Database

I am creating a query to get the 12 month of name and I also want month wise count for the UserLogi… Read more Get Current Year Of The 12 Month With Month Wise Count Data In Sql Server?

Is it possible to clear RAM memory from data that SQL Server fill in? Is there any procedure or opt… Read more Sql Server Clear Memory

I am going to create an app in Xamarin forms and starting with SQLite. I need to have unique list i… Read more Xamarin Forms Sqlite Relation

Still learning PHP so this maybe kind the same as others but having issues. I want to click edit o… Read more Edit Button To Open New Window To Allow Edits And Update Sql Server With Php Code

I have two tables registered and attended, each with two columns: AttendentId and SessionId. I woul… Read more Combining Sql Join With Count

I'm making a query dynamically like this: $query = 'SELECT u.* FROM users u … Read more How Can I Emulate Where 1 In A Dynamic Query?

I am using Grafana to make a graph of my data. I have 4 columns. The Time(using variable f), 2 sens… Read more Error 1064 In Grafana For Making A Graph Using Mysql Database

I have set a column name to 'group', which turned out to be a reserved word. Now I try to c… Read more Mysql Change Column Name From "group" To "group_code"

I'm trying to get the COLLECT function to work for me. I'm using 10g and therefore found t… Read more How To Use Collect With Varchar2 Oracle 10g

How can i concatenate the following string to make an SQL statement? Dim sql = 'SELECT * FROM u… Read more How To Concatenate String Correctly At End Of Array In Vba?

If I run the execution plan of an sp, Management Studio suggests an index. I add the index, run the… Read more After Adding Index Execution Plan Sqlserver Keeps Suggesting The Index

I'm trying to get a start and end date combination for continuous spans of time worked. The spa… Read more Sql: Find Continuous Date Ranges Across Multiple Rows?

I have a situation where a single patient can receive multiple services. These services can have o… Read more Determine Contiguous Dates In Sql Gaps And Islands

During build we generate dacpac files of our database based on a SSDT .sqlproject. This dacpac late… Read more Ssdt/sqlpackage Drops Statistics

I am developing a large django-based project. On my laptop I use SQLite3 as a database. I have crea… Read more Django Migrate Schema From Sqlite To Postgresql

This is similar to what I have now, which is: SELECT COUNT(author) FROM `posts` WHERE `date` >= … Read more How To Set Sql To Find Records From Last Sunday To This Sunday (1 Week)

I have the following psql table. It has roughly 2 billion rows in total. id word lemma … Read more Painfully Slow Postgres Query Using Where On Many Adjacent Rows

Possible Duplicate: Postgresql failed to start This problem has been driving me crazy and nothing… Read more Postgresql Changing Data Directory In Ubuntu

While I was able to find how to pivot this data in these forums, I have not been able to find a mea… Read more Dynamic Pivot Results To A Temp Table

Here is the my table : mysql> select * from t1; +------+-------+ | id | value | +------+------… Read more Mysql Update Statement Match Only The First Row

Here is my table. Price Volume ------------------ 60 0 70 10 80 0 90 … Read more Sql Query To Choose Row Before Two Consecutive True Values

If I transfer data from a Access MDB into a SQL Server, will DAO code in a VB app work against the … Read more Will Existing Dao Code Work Against A Sql Server?

Short background: We are just starting to migrate/reimplement an ERP system to Java with Hibernate,… Read more What Is The Best Default Transaction Isolation Level For An Erp, If Any?

Apologies in advance if this is a common question, I tried researching it but can't seem to fin… Read more Filtering Mysql Query Result Set To Yield Multiple Occurences Within A Specific Period Of Time

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 google about how to insert. But cant get any proper answer. I have to insert image from gall… Read more Image Upload In Sqlite Database Android

It's fairly obvious how to model a database table that would act as an access control list (ACL… Read more How To Build A Data Model For An Access Control List (acl)

I'm trying to delete an SQL result set but it won't work: DELETE FROM votes WHERE id IN ( S… Read more Delete An Sql Query Result Set

I use the SQL Server 2019 Import and Export wizard to import an Excel sheet (xlsx file) as source a… Read more Sql Server Import Wizard Doesn't Support Importing From Excel Sheet With More Than 255 Columns

Following this SO question, I'm trying to 'truncate' all tables related to a certain dj… Read more % Confuses Python Raw Sql Query

From following tables i have to fetch the list of users allowed in the specified group upon the bas… Read more Get Users(only Allowed) In Group In Single Mysql Query

I have a self-referencing table with a primary key, id and a foreign key parent_id. +------------+-… Read more Get Hierarchical Structure Using Sql Server

So, First of all. Code: I've got a class: public class Myobject { public string Code { ge… Read more How To Check If Datetime Object Was Not Assigned?

How do I change values of a column in an insert trigger ? In Oracle I can use the following code to… Read more Sql Server Change Column Value On Insert Trigger

I have two database tables, User and PageComment. Using Hibernate, I'm trying to store a Set of… Read more Hibernate One-to-many Could Not Initialise Collection

I am trying to learn Node.js and created a simple project to query the local database. But I get fa… Read more Unable To Connect To Microsoft Sql Server Using Node.js,mssql And Express