Recent questions tagged Sql

0 votes

887 views

1 answer

sql - An aggregate may not appear in the set list of an UPDATE statement

UPDATE [silverdb01].[dbo].[info] SET [FM] = SUM(a.[MONDAY] - b.[QUOTA]) FROM [silverdb01].[dbo].[ ... list of an UPDATE statement. Any ideas? See Question&Answers more detail:os...

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

0 votes

469 views

1 answer

sql server 2008 - Any other solutions for SQL's "The media set has 2 media families but only 1 are provided. All members must be provided." error?

I am trying to restore a 200mb database into SQL 2008 and I am getting this error "The media set has 2 media ... before we shut it down. Anyone? See Question&Answers more detail:os...

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

0 votes

571 views

1 answer

sql - GROUP BY in Postgres - no equality for JSON data type?

I have the following data in a matches table: 5;{"Id":1,"Teams":[{"Name":"TeamA","Players":[{" ... above. Does anyone have a better solution? See Question&Answers more detail:os...

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

0 votes

453 views

1 answer

sql server - Why is T-SQL ISNULL() truncating the string and COALESCE is not?

Given the following: SELECT ISNULL('XY' + NULL, 'ABCDEFGHIJ') -- Outputs ABC (Why?) SELECT ... these statements returning different results? See Question&Answers more detail:os...

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

0 votes

392 views

1 answer

sql server - Priority of a query in MS SQL

Is there a way to tell MS SQL that a query is not too important and that it can (and should) take its ... give higher priority to a query? See Question&Answers more detail:os...

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

0 votes

300 views

1 answer

sql server - Debugging does not show current stored procedure version

I'm working on a SQL Server 2008 R2 instance. I've just changed the code for a stored procedure. When I try ... of the code? Thanks in advance. See Question&Answers more detail:os...

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

0 votes

339 views

1 answer

sql - WHERE all IS NOT NULL

How can I run a MySQL query that selects everything that is not null? It would be something like SELECT * ... FROM schedule WHERE IS NOT NULL See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql - ERROR: column of relation does not exist PostgreSQL ,Unable to run insert query

Hi I am trying to insert into a table tester3 it fails when i use the syntax insert into tester3 ( ... PostgreSQL and also works without quotes See Question&Answers more detail:os...

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

0 votes

372 views

1 answer

sql - MySQL UPDATE with SUBQUERY of same table

I am working with a complex MySQL database table that collects form data. I have simplified the layout in an example ... idea how to help me? See Question&Answers more detail:os...

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

0 votes

503 views

1 answer

sql server 2005 - Call a Stored procedure in SQL CTE

Are you allowed to exec stored procedures within a SQL CTE statement? I'm a bit new to sql cte queries... See Question&Answers more detail:os...

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

0 votes

385 views

1 answer

sql server ce - Isn't an Int64 equal to a long in C#?

I have been playing around with SQL and databases in C# via SqlCeConnection. I have been using ExecuteReader to read ... an Int32 into a long. See Question&Answers more detail:os...

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

0 votes

494 views

1 answer

sql server - Are there disadvantages to using VARCHAR(MAX) in a table?

Here is my predicament. Basically, I need a column in a table to hold up an unknown length of ... solving this problem where available. See Question&Answers more detail:os...

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

0 votes

357 views

1 answer

sql server - One of the column between two columns should be NOT NULL. How to enforce it in schema?

I have a table with following scehma CREATE TABLE MyTable ( ID INTEGER DEFAULT(1,1), FirstIdentifier INTEGER NULL ... enforcing it via schema? See Question&Answers more detail:os...

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

0 votes

340 views

1 answer

sql server - Use database inside a stored procedure

I need to make a stored procedure which creates a user in more than one database. Something like this: USE [database1] ... . How can I do this? See Question&Answers more detail:os...

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

0 votes

487 views

1 answer

sql server - Can I have an optional OUTPUT parameter in a stored procedure?

I have a stored procedure that has a bunch of input and output parameters because it is Inserting values to ... , which was not supplied. See Question&Answers more detail:os...

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

0 votes

468 views

1 answer

sql - Find min and max for subsets of consecutive rows - gaps and islands

Trying to build a query. The input is ordered by rownumber in column 'rn' starting with 1 for each unique value ... order by name ,min(rn) See Question&Answers more detail:os...

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

0 votes

339 views

1 answer

sql - PostgreSQL row to columns

I'm trying to create a dynamic system that allows the users to import lists of data from Excel so I need to have ... know how can I do this? See Question&Answers more detail:os...

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

0 votes

5.4k views

1 answer

sql server - Audit trail with Entity Framework Core

I have an ASP.NET core 2.0 using Entity Framework core on a SQL Server db. I have to trace and audit all the ... the data I created.... why?? See Question&Answers more detail:os...

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

0 votes

462 views

1 answer

sql - MYSQL - Join most recent matching record from one table to another

I have two tables that look like this: Table: cases id name status case_no Table: notes id case_id ... pointers would be greatly appreciated See Question&Answers more detail:os...

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

0 votes

417 views

1 answer

sql server - How to implement logging and error reporting in SQL stored procedures?

Background I'm currently working on a project that heavily utilizes SQL stored procedures. Some tables have as many ... at the same time? See Question&Answers more detail:os...

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

0 votes

451 views

1 answer

sql - MySQL order posts by most recent comment OR last posted

How can I sort posts so most recent activity is on top? # Schema not including all info, including FKs CREATE ... reply is posted... Thanks! See Question&Answers more detail:os...

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

0 votes

282 views

1 answer

sql - MySQL Tree ordered by parent and child

I'm trying to display a tree structure in MYSQL with this reference (http://mikehillyer.com/articles/managing- ... E. Father Son Child Grandson See Question&Answers more detail:os...

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

0 votes

257 views

1 answer

sql - Is there a way to pivot rows to columns in MySQL without using CASE?

There are lots of posts out there on pivoting rows into columns for various databases. They seem to fall ... it would be greatly appreciated. See Question&Answers more detail:os...

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

0 votes

305 views

1 answer

sql - mysql query to dynamically convert row data to columns

I am working on a pivot table query. The schema is as follows Sno, Name, District The same name may appear ... to be transposed to the column. See Question&Answers more detail:os...

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

0 votes

551 views

1 answer

sql server - Python cant find ODBC Driver on Heroku after setting everything

I have gone through every possible solution on the internet, but I'm unable to make pyobdc get the drivers on ... pointers to make this work. See Question&Answers more detail:os...

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

0 votes

782 views

1 answer

sql - How to "reset" running SUM after it reaches a threshold?

I wrote a query that creates two columns: the_day, and the amount_raised on that day. Here is what I have: And ... a RESET function?). Thank you See Question&Answers more detail:os...

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

0 votes

405 views

1 answer

sql - Combine OUTPUT inserted.id with value from selected row

Running SQL Server 2014. How can I insert multiple rows from a table and combine the inserted data with the new ... and then joining on RowID. See Question&Answers more detail:os...

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

0 votes

455 views

1 answer

sql - MSSQL dynamic pivot column values to column header

Could someone help me convert the following on mssql please? ID | PROPERTY_NAME | PROPERTY_VALUE 1 | name1 | ... (@query) Many thanks, Mike See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags