Recent questions tagged SQL

0 votes

1.0k views

1 answer

listagg is a function introduced in Oracle 11.2! now this function is bugging us allot, we are migrating from ... solution for it? thanks you See Question&Answers more detail:os...

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

0 votes

353 views

1 answer

sql - Mysql query to join three tables

I am using this query: SELECT a.sales_id, d.bus_title, a.cat_id FROM tbl_sales a INNER JOIN tb_category b ON ... , need help. Thanks in advance See Question&Answers more detail:os...

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

0 votes

754 views

1 answer

sql - Reuse identity value after deleting rows

Is it possible to reuse an identity field value after deleting rows in SQL Server 2008 Express? Here is an ... this? Thanks for your help. See Question&Answers more detail:os...

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

0 votes

435 views

1 answer

sql - Select random sampling from sqlserver quickly

I have a huge table of > 10 million rows. I need to efficiently grab a random sampling of 5000 from it. I ... there a faster way to do this? See Question&Answers more detail:os...

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

0 votes

479 views

1 answer

sql - mysql slow on first query, then fast for related queries

I have been struggling with a problem that only happens when the database has been idle for a period of time ... I can troubleshoot the issue. See Question&Answers more detail:os...

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

0 votes

471 views

1 answer

sql - Cannot use group by and over(partition by) in the same query?

I have a table myTable with 3 columns. col_1 is an INTEGER and the other 2 columns are DOUBLE. For example, ... experience with SQL. Thank you. See Question&Answers more detail:os...

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

0 votes

401 views

1 answer

sql server - when/what locks are hold/released in READ COMMITTED isolation level

I am trying to understand isolation/locks in SQL Server. I have following scenario in READ COMMITTED isolation level( ... till we reach COMMIT. See Question&Answers more detail:os...

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

0 votes

630 views

1 answer

sql - Combine two SELECT queries in PostgreSQL

I would like to combine two select queries with UNION. How can I use the result from the first SELECT in ... the carto_id result from above> ) See Question&Answers more detail:os...

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

0 votes

285 views

1 answer

sql - Do you put your database static data into source-control ? How?

I'm using SQL-Server 2008 with Visual Studio Database Edition. With this setup, keeping your schema in sync is ... manage your DB static data ? See Question&Answers more detail:os...

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

0 votes

479 views

1 answer

sql - Disable and later enable all table indexes in Oracle

How would I disable and later enable all indexes in a given schema/database in Oracle? Note: This is to make sqlldr run faster. See Question&Answers more detail:os...

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

0 votes

465 views

1 answer

sql - What are the main differences between OPTION(OPTIMIZE FOR UNKNOWN) and OPTION(RECOMPILE)?

I run into the classic Parameter Sniffing issues in SQL Server 2012. Based on some research I found multiple ... of recompiling each time? See Question&Answers more detail:os...

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

0 votes

819 views

1 answer

sql - The wait operation timed out. ASP

I created an internal website for our company. It run smoothly for several months and then I made a major update ... will be fix the problem? See Question&Answers more detail:os...

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

0 votes

456 views

1 answer

sql - Is it possible to use Aggregate function in a Select statment without using Group By clause?

So far I have written Aggregate function followed by Group By clause to find the values based on SUM, AVG ... without using Group By clause. See Question&Answers more detail:os...

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

0 votes

456 views

1 answer

sql server - Fastest way to find string by substring in SQL?

I have huge table with 2 columns: Id and Title. Id is bigint and I'm free to choose type of Title column: ... be useless, as far as I see. See Question&Answers more detail:os...

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

0 votes

611 views

1 answer

sql - Convert MySQL script to H2

I have an init script for my MySQL database but for test purposes I wan't to use a H2 database. Anyone ... of the syntax differences ? thanks. See Question&Answers more detail:os...

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

0 votes

372 views

1 answer

sql - Multiple foreign keys to a single column

I'm defining a database for a customer/ order system where there are two highly distinct types of customers. ... the relationships like this? See Question&Answers more detail:os...

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

0 votes

429 views

1 answer

sql server - When I update/insert a single row should it lock the entire table?

I have two long running queries that are both on transactions and access the same table but completely separate rows ... this sort of issue? See Question&Answers more detail:os...

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

0 votes

531 views

1 answer

sql - MySQL CASE to update multiple columns

I would like to update multiple columns in my table using a case statement, but I cannot find how to do ... the expected result with valid SQL? See Question&Answers more detail:os...

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

0 votes

467 views

1 answer

sql server - SQL to return list of years since a specific year

I need a list of years as a recordset starting with 2004 to current year (in desc order), without writing a ... : 2009 2008 2007 2006 2005 2004 See Question&Answers more detail:os...

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

0 votes

558 views

1 answer

sql server - Visual Studio 2017 does not have Business Intelligence Integration Services/Projects

I do not see an option to create an SSIS project using Visual Studio 2017. See Question&Answers more detail:os...

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

0 votes

340 views

1 answer

sql - Update existing database values from spreadsheet

I have an existing MSSQL database where the values in some columns need updating according to a spreadsheet which contains ... c=new3, d=new4? See Question&Answers more detail:os...

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

0 votes

508 views

1 answer

sql server - Recursively find all ancestors given the child

Given a child id, I need to return a query containing all parents of that child as well as their parents ... help would be appreciated. Thanks See Question&Answers more detail:os...

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

0 votes

406 views

1 answer

sql server - SQL script to "copy" a database

I want to write a SQL script that will copy a database on the same server. I could do a backup/restore, ... HD, and then reattach both copies? See Question&Answers more detail:os...

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

0 votes

576 views

1 answer

sql - Using MySQL IN clause as all inclusive (AND instead of OR)

I have a listing of items on a site. Each item has several categories attached to it, let's call these ... equals the 4 category Ids. See Question&Answers more detail:os...

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

0 votes

431 views

1 answer

sql - How does Subquery in select statement work in oracle

I have looked all over for an explanation, to how does the subquery in a select statement work and still I cannot ... but I am not too sure. See Question&Answers more detail:os...

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

0 votes

379 views

1 answer

sql server 2008 - How to add time to DateTime in SQL

I'm trying to add custom time to datetime in SQL Server 2008 R2. Following is what I've tried. SELECT ... to add custom time to datetime? See Question&Answers more detail:os...

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

0 votes

345 views

1 answer

sql server - What are the real benefits of Visual Studio Team System Database Edition (GDR)?

Interested if anyone has used VSTS Database Edition extensively and, if so, which features did you find ... -b1c9-8f55759846ed&displaylang=en] See Question&Answers more detail:os...

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

0 votes

633 views

1 answer

sql - Postgres: define a default value for CAST failures?

Is it possible to define a default value that will be returned in case a CAST operation fails? For example, ... instead of throwing an error? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags