Recent questions tagged SQL

0 votes

413 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

685 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

438 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

419 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

541 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

600 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

488 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

686 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

363 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

699 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

372 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

412 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

338 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

423 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

463 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

329 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

359 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

334 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

368 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.0k 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

331 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

552 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

296 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

436 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

470 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

320 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

258 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