Recent questions tagged SQL

0 votes

492 views

1 answer

sql server - Duplicating rows based on a column value in each row

I've this table with the following data Job Quantity Status Repeat 1 100 OK 2 2 400 HOLD 0 3 200 HOLD 1 4 ... this query? I'm using sql server See Question&Answers more detail:os...

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

0 votes

604 views

1 answer

sql - Selecting specific columns using linq: What gets transferred?

I refer to this example: Return selected specified columns Quote: If BlobDetails isn't the LINQ entity, then you ... from a table through LINQ? See Question&Answers more detail:os...

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

0 votes

702 views

1 answer

sql - LINQ Joins - Performance

I am curious on how exactly LINQ (not LINQ to SQL) is performing is joins behind the scenes in relation to how ... or does it always use one? See Question&Answers more detail:os...

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

0 votes

698 views

1 answer

sql - MySQL UPDATE with SELECT SUM from different table

I have two tables: ITEMS with quantities and unit_price (id | name | order_id | qt | unit_price) and table ... orders.id = items.order_id) See Question&Answers more detail:os...

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

0 votes

580 views

1 answer

sql - Simulating CTE recursion in C#

Say that have the following CTE that returns the level of some tree data (adjacency model) that I have (taken ... do using a lambda expression. See Question&Answers more detail:os...

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

0 votes

586 views

1 answer

sql - Get Id from a conditional INSERT

For a table like this one: CREATE TABLE Users( id SERIAL PRIMARY KEY, name TEXT UNIQUE ); What would be ... ON CONFLICT do not belong together. See Question&Answers more detail:os...

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

0 votes

587 views

1 answer

sql - How to determine whether the number is float or integer

I need to write this query in SQL Server: IF isFloat(@value) = 1 BEGIN PRINT 'this is float number' END ELSE ... help me out with this, thanks. See Question&Answers more detail:os...

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

0 votes

562 views

1 answer

sql - Slow query ordering by a column in a joined table

Introducing an ORDER BY clause in a query increases the total time due the extra work that the db have to do in order to ... -+------- 1 | 17540 See Question&Answers more detail:os...

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

0 votes

521 views

1 answer

sql server - get new SQL record ID

How can I get back the autogenerated ID for a new record I just inserted? (Using ASP classic and MSSQL 2005) See Question&Answers more detail:os...

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

0 votes

507 views

1 answer

sql server - How to add more OR searches with CONTAINS Brings Query to Crawl?

I have a simple query that relies on two full-text indexed tables, but it runs extremely slow when I have the ... '"*fa*"') Execution Plan: See Question&Answers more detail:os...

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

0 votes

827 views

1 answer

sql - UNNEST function in MYSQL like POSTGRESQL

Is there a function like "unnest" from POSTGRESQL on MYSQL? Query (PSQL): select unnest('{1,2,3,4}'::int[]) ... _____| 3 | _____| 4 | _____| See Question&Answers more detail:os...

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

0 votes

639 views

1 answer

sql - SQLite3 Simulate RIGHT OUTER JOIN with LEFT JOINs and UNION

I have the following select statement where I need to sum each task from table tbTasks and group them by projectId ... way to achieve my goal? See Question&Answers more detail:os...

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

0 votes

531 views

1 answer

sql - MySql count() to return 0 if no records found

I have a set of posts on monthly basis. Now i need an array which contains total records of posts posted in each month. I ... ---------------+ See Question&Answers more detail:os...

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

0 votes

636 views

1 answer

sql - Return id if a row exists, INSERT otherwise

I'm writing a function in node.js to query a PostgreSQL table. If the row exists, I want to return the id column ... 't seem to get it to work. See Question&Answers more detail:os...

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

0 votes

662 views

1 answer

sql - Does Liquibase support dry run?

We have couple of data schemas and we investigate the migration to Liquibase. (One of data schemas is already ... our schemas. Please help. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql server - Serilog.Sinks.MSSqlServer not filling custom columns

I've looked around, but I could not find a working solution, and since all examples look alike I assume it must ... 'ernst' order by id desc; See Question&Answers more detail:os...

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

0 votes

508 views

1 answer

sql - SELECT FOR XML AUTO and return datatypes

During playing with sys.dm_exec_describe_first_result_set I get to this point: CREATE TABLE #tab(col INT, x XML ... normal/temp table? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql - ORA-01219: database not open: queries allowed on fixed tables/views only

I Am using oracle 11g and SQL developer tool. When i tried to retrieve rows from db i am getting error message ... help me to make it working. See Question&Answers more detail:os...

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

0 votes

476 views

1 answer

sql - Detect duplicate items in recursive CTE

I have a set of dependencies stored in my database. I'm looking to find all the objects that depend on the ... huge waste of time and resource. See Question&Answers more detail:os...

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

0 votes

575 views

1 answer

sql server - MySQL INSERT with OUTPUT like MSSQL

I am pretty sure MySQL does not have the INSERT INTO table OUTPUT [column value] that MSSQL does - http://msdn ... UID prior to insert?) Thanks See Question&Answers more detail:os...

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

0 votes

828 views

1 answer

sql - Performance value of COMB guids

Jimmy Nilsson discusses his COMB guid concept here. This concept is popular in NHibernate, among other circles, ... gain appears non-existent. See Question&Answers more detail:os...

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

0 votes

518 views

1 answer

sql - Using a SELECT statement within a WHERE clause

SELECT * FROM ScoresTable WHERE Score = (SELECT MAX(Score) FROM ScoresTable AS st WHERE st.Date = ScoresTable.Date) Is ... and Score (e.g. name) See Question&Answers more detail:os...

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

0 votes

627 views

1 answer

sql - how to assign cte value to variable

;with CTEima(PersonId,IsEmployeeActive) as (select count(*) from custom.viwSSAppsEmpMasterExtended vem where vem. ... CTE into variable See Question&Answers more detail:os...

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

0 votes

536 views

1 answer

sql - Why can't I GROUP BY 1 when it's OK to ORDER BY 1?

Why are column ordinals legal for ORDER BY but not for GROUP BY? That is, can anyone tell me why this ... about an overall answer nonetheless. See Question&Answers more detail:os...

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

0 votes

620 views

1 answer

sql server - How do I call a stored procedure with arguments using sqlcmd.exe?

I need to call a stored procedure and pass arguments in from Powershell. I think the best option is to use ... the stored proc using this tool. See Question&Answers more detail:os...

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

0 votes

415 views

1 answer

sql - How Do I Deep Copy a Set of Data, and Change FK References to Point to All the Copies?

Suppose I have Table A and Table B. Table B references Table A. I want to deep copy a set of rows ... with no repercussions. Thanks, Tedderz See Question&Answers more detail:os...

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

0 votes

532 views

1 answer

sql - MYSQL ERROR 1248 (42000): Every derived table must have its own alias

I cant for the life of me figure out why this is erroring SELECT * FROM SELECT c.city_id, p.prop_ynow_id, p. ... limit 46 as a limit 0,50 See Question&Answers more detail:os...

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

0 votes

554 views

1 answer

sql - MySQL - Get a counter for each duplicate value

I have a table with two columns. +------+------+ | data | num ?| +------+------+ ... besides a mySQL query? UPDATE: extended question here See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags