Recent questions tagged SQL

0 votes

445 views

1 answer

sql - Inserting a COALESCE(NULL,default)

I have tables that use UUIDs. I want to be able to insert a new row with or without a UUID as sometimes ... this be better done with plpgsql? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

713 views

1 answer

sql server - VB6 ADODB.Recordset RecordCount property always returns -1

I am trying to get some old VB6 code to work with SQL Server Compact. I can connect, open the database ... advice would be gratefully accepted. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

479 views

1 answer

sql server - Changing the output of Getdate

Is it possible to deceive SQL Server to return a different date on GetDate() without actually changing the machine date ... .. Any tips? Thanks! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

456 views

1 answer

sql - Select Top N Records Ordered by X, But Have Results in Reverse Order

I'm trying to get the top N records (when ordered by some column X), but have the result set ... them returned in forward chronological order. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

sql - The local psql command could not be located

I'm following the instructions found here. When I try to run $ heroku pg:psql or $ heroku pg:psql HEROKU ... and teaching myself as I go. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

576 views

1 answer

sql server - How to cascade delete over many to many table

I have a 3 tables that look like this: (source: InsomniacGeek.com) On the foreign keys I have set cascade ... Or is there any better solution? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

629 views

1 answer

sql - SQLite equivalent of PostgreSQL's GREATEST function

PostgreSQL has a useful function called GREATEST. It returns the largest value of those passed to it as documented ... work with 2 arguments. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

524 views

1 answer

sql - "An item with the same key has already been added" Error on SSRS When Trying to Set Dataset

When i try to set the Dataset in SSRS IDE, i get the error you see in the snapshot. The ... WHERE CustomerInvoice.cuInvoiceID = @cuInvID See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

720 views

1 answer

sql server - "Operation is not allowed when the object is closed" when executing stored procedure

This is my stored procedure, and when I am calling it from my classic ASP code, I am ... .RecordCount response.write(NumOfNewHireWorkPeriods) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

392 views

1 answer

sql - Getting the floor value of a number in SQLite?

I have a SQLite database with a table containing the scores of some league players in a bowling center. I'm ... it all in SQL if possible. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

732 views

1 answer

sql - What's the equivalent for LISTAGG (Oracle database) in PostgreSQL?

I have to replace the Oracle driver with the newest PostgreSQL. PostgreSQL doesn't know the function LISTAGG ... function LISTAGG in PostgreSQL? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

397 views

1 answer

sql - Access get all tables

Is there a way in by sql statement or vba code to return all tables from access file? "I don't know the name of ... how to get all tables?!!!! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

439 views

1 answer

sql - Microsoft Access Query Should return true or true and false, only returns true

I am making an access query . There is a field with a Yes/No box. The query criteria parameter is IIf([Type ... then it returns both Yes and No. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

367 views

1 answer

sql server - Crystal Report Datasource remap

I am working with Crystal Reports and MS SQL Server. I need to remap the crystal report to point to a ... in advance. Yours trully, Silviu. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

457 views

1 answer

sql - Increasing MySQL Query performance - Math heavy query

Anyone willing to help me with this? The following query takes about 18 seconds on a MEMORY table with ... GROUP BY date(todaydata.postdate) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

495 views

1 answer

sql - Dynamic Pivot Needed with Row_Number()

I am using Microsoft SQL Server Management Studio 2008. I have data that looks like this: Client ID Value ------- ... ,1,2,'') order by ClientID See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

357 views

1 answer

sql - Calculate the SUM of the Column which has Time DataType:

I want to calculate the Sum of the Field which has Time DataType. My Table is Below: TableA: TotalTime ------- ... 36:00 How to get this Output? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

389 views

1 answer

sql - Why would SqlServer select statement select rows which match and rows which match and have trailing spaces

I have a table created with: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [ ... its own, with no space? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

363 views

1 answer

sql server - SQL query to sum the data

I have my table data as follows TaxTypeCode1 TaxTypeCode2 PNO Amount ----------------------------- ... how to write query to retrieve that data? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

395 views

1 answer

sql server - Concatenate multiple rows into one field

I have a table with three column like image (Source) and want to write a query that give a table like image (Result) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

sql - How do I ensure integrity between unrelated tables?

I just recently started learning database design, and I'm am working with Oracle 11G and SQL Developer. I have ... 13" on the SUBSCRIBE TABLE. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

357 views

1 answer

sql - MS Access 2010 Running Total in Query

I am not a big Access fan but for this project I was asked to create an Access database. I created something ... to 0 when the agent changes. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

580 views

1 answer

sql - Amazon Redshift - lateral column alias reference

Based on Amazon Redshift announces support for lateral column alias reference: The support for lateral ... function/references/subqueries? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

322 views

1 answer

sql - Replace row value with empty string if duplicate

is it possible to replace row value with empty string if duplicate value found? For example SELECT ProductCode, ... using SQL Server 2012. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

464 views

1 answer

sql - SSIS hidden sheets as Excel Destination

As occurring more often something simple is not so simple in SSIS (v 2008) Situation before B.I. came in: data ... in advance for any advice!! L See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

507 views

1 answer

sql - Duplicate groups of records to fill multiple date gaps in Google BigQuery

I've found a similar question (Duplicating records to fill gap between dates in Google BigQuery), however with a ... has happened. Any ideas? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

349 views

1 answer

sql - Remove duplicate rows in a table

I have a table contains order information like below: Order table: As we can see from that table, each order_no has ... , I am using Oracle 10) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

289 views

1 answer

sql - Put pg_try_advisory_xact_lock() in a nested subquery?

In my Ruby on Rails 4 app, I have this query to a Postgres 9.4 database: @chosen_opportunity = Opportunity.find_by_sql ... clause? How to do it? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags