Recent questions tagged SQL

0 votes

1.2k views

1 answer

sql server - How to create BAK file from azure sql db

I want to move my azure sql db to another host. However my new host allows to import sql db backup-files (. ... my azure sql db. Please help. See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql - Oracle: Similar to sysdate but returning only time and only date

I understand that Oracle sysdate returns the current date AND time. That's great for timestamp or datetime columns. Now ... values(???) Thanks! See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql server - SQL Query - Delete duplicates if more than 3 dups?

Does anyone have an elegant sql statement to delete duplicate records from a table, but only if there are more ... than say 2 duplicates. Thanks See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - MySQL byte-for-byte comparison, which is faster? binary vs bin_collate

Assume we have a table that looks like this: create table t1(c1 varchar(x)collate utf8mb4_general_ci, index ... interested in btree comparison.) See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql server split comma separated values into columns

I trying to split the csv to individual columns SAMPLE DATA PAR_COLUMN PERIOD VALUE mul_query ------- ... RUNNING Multiplication in Value column See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql server - How to modify the variable in SSIS?

I have a simple String variable with the following value: "C:Test.txt". Now I would like to edit the ... , see the accepted answer below. 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 get rows having sum equal to given value

There is table contain ID Qty ---------- 1 2 2 4 3 1 4 5 Now if i had to choose rows ... row/rows having combination equals to given value. See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql - how to use distinct in ms access

I have two tables. Task and Categories. TaskID is not a primary key as there are duplicate values.When there ... distinct values in ms access? See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql - Cannot have a qualifier in the select list while performing a JOIN w/ USING keyword

I am looking at a practice test that doesn't have explanations about the correct answers. The question I'm ... this? I am pretty stumped. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - How can one iterate over stored procedure results from within another stored procedure....without cursors?

I'm not sure if this is something I should do in T-SQL or not, and I'm pretty sure using the word 'iterate ... be an easy one for you sql gurus! See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - Why WHEN MATCHED' cannot appear more than once in a 'UPDATE' clause of a MERGE statement?

I'm taking a bunch of CRUD opertations and creating merge storedprocs off the CUD. My stored proc looks like ... storedproc when @Action is 0? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - Entity Framework Indexing ALL foreign key columns

This may be too much of an opinion-based question but here goes: I've found an interesting quirk with Entity ... concept that I'm missing. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - Can we have the table name as "option" in MySQL?

I am very, very new to MYSQL.I tried to create a table named "option". My SQL Query is : create table ... name as "option" in mysql? thanks See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql server - Using PATINDEX to find varying length patterns in T-SQL

I'm looking to pull floats out of some varchars, using PATINDEX() to spot them. I know in each varchar ... one single valid PATINDEX pattern? See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql - Using IF EXISTS with a CTE

I want to check if a CTE table has record or null. But I always get error message 'Incorrect syntax near the ... 'OK' ELSE PRINT 'NOT OK' See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - How to insert into a table that specifies a DEFAULT value for every column?

I have a table where all columns are auto-populated whenever an insertion happens: CREATE TABLE ( ItemID INT ... must be manually provided.) See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql - Reference value of serial column in another column during same INSERT

I have a table with a SERIAL primary key, and also an ltree column, whose value I want to be the ... two (grouped in a transaction). See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql server - BETWEEN operator vs. >= AND <=: Is there a performance difference?

These two statements are logically equivalent: SELECT * FROM table WHERE someColumn BETWEEN 1 AND 100 SELECT * FROM ... one versus the other? See Question&Answers more detail:os...

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

0 votes

1.7k views

1 answer

sql order by - LINQ : Distinct and Orderby

I am trying to use LINQ (to EF) to get a DISTINCT list and then sort it. All the examples I found sort ... so the result is: 8x10 10x10 40x40 See Question&Answers more detail:os...

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

0 votes

2.1k views

1 answer

sql - The object name contains more than the maximum number of prefixes. The maximum is 3

My stored procedure is trying to write a record in to a database on another Server. The statement is here: IF ... I can get around this? Thanks See Question&Answers more detail:os...

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

0 votes

1.9k views

1 answer

sql server - How to reuse a sub query in sql?

I have query like the following select columns from (select columns1 from result_set where condition_common and ... in a single statement See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

sql - Pass a list of integers from C# into Oracle stored procedure

I have a oracle stored procedure which updates a table with the following statement. update boxes set location = ' ... this. Thanks in advance! See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql server - CAST(DATETIME AS DATE) over WHERE clause

I'm using SQL Server 2012 and I would like to know if I write the sentence: SELECT MyDateTimeColumn FROM ... /convert to probe it myself. See Question&Answers more detail:os...

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

0 votes

1.2k 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

1.4k 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

1.5k views

1 answer

sql - Array combinations without repetition

I would like to make combinations out from an int[] {2,4,6,7,8,10,13,15,16,18} should give ... only solution without using custom functions? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql server - WinRT System.Data - Connect to SQL

Just want to make sure I am not missing something. There does not appear to be a WinRT System.Data. What I ... in a App Store compliant manner. See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql server 2005 - Business Days calculation

I have a query where I am calculating total days between two days including start and end date by the following ... between two dates? Thank you See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags