Recent questions tagged sql

0 votes

512 views

1 answer

sql - Oracle: is there any logical reason not to use parallel execution with subqueries in the SELECT list?

Is there any logical reason for Oracle not to use parallel execution with scalar subqueries in the SELECT list? Why ... are in the SELECT list. See Question&Answers more detail:os...

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

0 votes

712 views

1 answer

sql server - Tally Table to insert missing dates between two dates? SQL

I pieced together the below code from research from the net and my own SQL knowledge (not the greatest). ... the performance is terrible. Thanks See Question&Answers more detail:os...

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

0 votes

687 views

1 answer

sql - Efficient query to split a delimited column into a separate table

I have some data that includes a column with delimited data. There are multiple records in the same column ... join operations more quickly? See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

sql - How to implement total disjoint specialization in database?

Say there is a database for students and professors (a very simple one) and the relational database is the following ... , just let me know. See Question&Answers more detail:os...

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

0 votes

474 views

1 answer

sql - Copy multiple records with a master-details relationship

I am facing a problem in SQL Server with copying multiple related tables at a time. I have two ... WHERE EventID = @ParentEventID; See Question&Answers more detail:os...

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

0 votes

633 views

1 answer

sql server - Foreign Key Referencing Multiple Tables

I have a column with a uniqueidentifier that can potentially reference one of four different tables. I have seen ... ONLY those tables. Thanks! See Question&Answers more detail:os...

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

0 votes

671 views

1 answer

sql server - Storing SqlServer's raiserror message in C#

How can I store SQLSERVER's raiserror message in C# ? See Question&Answers more detail:os...

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

0 votes

643 views

1 answer

sql server - Get default value of stored procedure parameter

I have created below stored procedure with default value: CREATE PROCEDURE [dbo].[Sample1] @OrderID INT = 10285 AS ... way to get default value? See Question&Answers more detail:os...

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

0 votes

616 views

1 answer

sql - Convert a string to a date in Access

I'm migrating data between tables in Access 2003. In the old table, the date was stored as a text field in ... results. What am I doing wrong? See Question&Answers more detail:os...

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

0 votes

802 views

1 answer

sql server - Find Mondays between 2 dates

I need to display dates of all Mondays in the given date range. For example, if my start date is 01/05/2015 ... 25/05/2015 How is it possible? See Question&Answers more detail:os...

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

0 votes

647 views

1 answer

sql - There is already an object named '#result' in the database

Alter Procedure sp_Member( @comcode int = 0, @SubComCode int = 0 ) as begin set nocount on If @comcode='0' ... tell me what the problem is? See Question&Answers more detail:os...

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

0 votes

685 views

1 answer

sql - Redshift split single dynamic column into multiple rows in new table

With a table like: uid | segmentids -------------------------+-------------------- ... index in string, which is dynamic here. Any suggestions? See Question&Answers more detail:os...

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

0 votes

721 views

1 answer

sql - Find TOP 10 latest record for each BUYER_ID for yesterday's date

This is the below table CREATE TABLE IF NOT EXISTS TestingTable1 ( BUYER_ID BIGINT, ITEM_ID BIGINT, CREATED_TIME STRING ... any UDF in HiveQL? See Question&Answers more detail:os...

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

0 votes

556 views

1 answer

sql - Postgres trigger-based insert redirection without breaking RETURNING

I'm using table inheritance in postgres, but the trigger I'm using to partition data into the ... EXECUTE PROCEDURE flag_insert_trigger_fun(); See Question&Answers more detail:os...

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

0 votes

810 views

1 answer

sql server - Get default value of stored procedure parameter

I have created below stored procedure with default value: CREATE PROCEDURE [dbo].[Sample1] @OrderID INT = 10285 AS ... way to get default value? See Question&Answers more detail:os...

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

0 votes

528 views

1 answer

sql - Converting Numbers to Words in MYSQL result! Using Query

I am trying to print a output as follows when I execute a query in mysql. Name Salary Sal_in_Words Mohan 45000 ... there any way to do it? See Question&Answers more detail:os...

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

0 votes

690 views

1 answer

sql - On delete cascade for self-referencing table

I have a comment table that is self-referencing. I tried to write on delete cascade but it take some ... for my self-referencing table? See Question&Answers more detail:os...

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

0 votes

799 views

1 answer

sql server - Is MS-SQL AND/OR conditional (perform short-circuit evaluation)?

I'm creating an stored procedure as this (simplified) create procedure sp_mysp @p1 bit AS if (@p1 = 1 AND EXISTS( ... (something like && in c#) See Question&Answers more detail:os...

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

0 votes

619 views

1 answer

sql server - Php calling sqlserver backup database script, backup file created and then deleted

I have a php calling sqlserver backup script. The script, if executed directly from SSMS, it created the backups ... =@fileName WITH STATS = 1 See Question&Answers more detail:os...

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

0 votes

661 views

1 answer

sql - Two columns in subquery in where clause

I have a query: SELECT s.period, s.year, s.amount FROM salaries s I would like to select from salaries table ... .period AND s.year = p.year See Question&Answers more detail:os...

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

0 votes

614 views

1 answer

sql server - how to find rowsize in table

One of my DBs have grown closer to permitted size. Inorder to find out the table containing the max data, i used ... there any tools to do this? See Question&Answers more detail:os...

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

0 votes

745 views

1 answer

sql - Recursive CTE to find parent records

first i must admit that i'm not very familiar with sql server's recursive CTE's but i think this is the ... tabData_Temp]; Thank you in advance. See Question&Answers more detail:os...

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

0 votes

861 views

1 answer

sql server - SQL How to Update SUM of column over group in same table

I have a (SQL Server) table similar to the following: SalesSummary Year | Team | Person | Person Sales | ... . Apologies if this is obvious. See Question&Answers more detail:os...

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

0 votes

642 views

1 answer

sql - GROUP or DISTINCT after JOIN returns duplicates

I have two tables, products and meta. They are in relation 1:N where each product row has at least one ... query but always with same result. See Question&Answers more detail:os...

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

0 votes

760 views

1 answer

sql - Converting Long to Varchar2

I am trying to insert into varchar2 column from a long column. here is the below example, TEXT.TEXT_COL = ... Let me know your thoughts. See Question&Answers more detail:os...

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

0 votes

624 views

1 answer

sql - ORDER BY Alias not working

UPDATING QUESTION: ERROR: column "Fruits" does not exist Running Postgres 7.4(Yeah we are upgrading) Why can't I ORDER ... ;490 "Other";x;x;x;x See Question&Answers more detail:os...

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

0 votes

675 views

1 answer

sql - MySQL Truncating of result when using Group_Concat and Concat

I have the following SQL (I have removed some of the selesct fi: SELECT node_revisions.title AS 'Task', ... to be at 341ish chars) See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql - MySQL error: Missing index for constraint

I am creating 2 tables in my database: DROP TABLE IF EXISTS `med_pharmacy`; CREATE TABLE IF NOT EXISTS ` ... but I changed one field. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags