Recent questions tagged SQL

0 votes

665 views

1 answer

sql - Fill In The Date Gaps With Date Table

I have two tables. An orders table with customer, and date. A date dimension table from a data warehouse. The ... d.calendaryear IN ( 2012 ); See Question&Answers more detail:os...

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

0 votes

371 views

1 answer

sql - Oracle Insert Select with order by

I am working on a plsql procedure where i am using an insert-select statement. I need to insert into the ... to insert rows in orderly fashion? See Question&Answers more detail:os...

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

0 votes

366 views

1 answer

sql server - Conversion failed when converting the varchar value in case statement

I cant not get my head around it. We have following simple query. DECLARE @bFlag bit SET @bFlag = 0 SELECT ... to convert 'Weeks' to int? See Question&Answers more detail:os...

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

0 votes

409 views

1 answer

sql server - cascading deletes causing multiple cascade paths

I am using SQlServer 2008, and an extract of some datatables is displayed below: Users Id (PK) UserItems UserId ( ... I want from SQL Server? See Question&Answers more detail:os...

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

0 votes

399 views

1 answer

sql - Possible recursive CTE query using date ranges

Not sure how to even phrase the title on this one! I have the following data: IF OBJECT_ID ('tempdb..#data' ... ) ORDER by MAX(level) ASC See Question&Answers more detail:os...

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

0 votes

485 views

1 answer

sql server - How to execute a 32 bit SSIS package in a 64bit package?

I'm working on a Integration Services project in order to build an ETL. One of my packages contains multiple ... a 64bit package ? Thanks ! See Question&Answers more detail:os...

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

0 votes

842 views

1 answer

sql - ORA-30926: unable to get a stable set of rows in the source tables when Merging tables

I have this Merge statement: MERGE INTO TB_DP_REGIAO B USING TMP_DP_REGIAO P ON (P.DS_PROTHEUS_CODE = B. ... ? Thanks in advance! See Question&Answers more detail:os...

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

0 votes

416 views

1 answer

sql server - TSQL UDF To Split String Every 8 Characters

Someone decided to stuff a bunch of times together into a single column, so the column value might look like this: ... existing UDF to do this? See Question&Answers more detail:os...

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

0 votes

340 views

1 answer

sql - Mysql WHERE problem with comma-separated list

I need help for this problem. In MYSQL Table i have a field : Field : artist_list Values : 1,5,3,401 I need to ... (match for 30, 33, 3333)... See Question&Answers more detail:os...

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

0 votes

295 views

1 answer

sql server - Updating Data Provider of Crystal Reports

I have created number of Crystal Reports in My VB.NET Project getting data from Microsoft Access 2007 (.accdb) ... My Crystal Reports? Thanks. See Question&Answers more detail:os...

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

0 votes

413 views

1 answer

sql - Mysql count occurrence by group

Hi i have following table on mysql DB. ╔═══════════╦═════════╦════════╦════════════════╗ ║ REVIEW_ID ║ ... ╚════════╩════════════╝ Thanks See Question&Answers more detail:os...

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

0 votes

385 views

1 answer

sql - Joining two tables in a MySQL

I have the following table called votes: I'm trying to join a list of items, with a users table, and this ... EDIT: Here's the list_items table: See Question&Answers more detail:os...

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

0 votes

383 views

1 answer

sql - Select records skipping rows in MS Access

How do I can select some records on database skipping a number o rows in MS Access. In MySQL is LIMIT x, y. ... No lucky on Google at all =( See Question&Answers more detail:os...

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

0 votes

537 views

1 answer

sql server - how to export sql data to csv using bcp

I use simple code declare @sql varchar(8000) select @sql = 'bcp ExcelAnalysis.dbo.ClearDB out c:csvcomm.txt -c ... his syntax. How do correct? See Question&Answers more detail:os...

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

0 votes

432 views

1 answer

sql - MySQL second auto increment field based on foreign key

I've come across this problem numerous times but haven't found a "MySQL way" to solve the issue as such - I ... was a different way to do this? See Question&Answers more detail:os...

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

0 votes

453 views

1 answer

sql - Odd INNER JOIN syntax and encapsulation

I'm usually pretty well versed with JOINS, but this is new. Suppose three tables (classic case of two tables and ... be applied to others...) See Question&Answers more detail:os...

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

0 votes

346 views

1 answer

sql - Converting delimited string to multiple values in mysql

I have a mysql legacy table which contains an client identifier and a list of items, the latter as a comma- ... the individual items on demand? See Question&Answers more detail:os...

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

0 votes

638 views

1 answer

sql - maximum and minimum number of tuples in natural join

I came across a question that states Consider the following relation schema pertaining to a students database: Student ... help in this regard See Question&Answers more detail:os...

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

0 votes

476 views

1 answer

sql server - How do I control parameter sniffing and/or query hints in entity framework?

Update: I've created a suggestion to implement hint control in a future version of EF. Go here to vote for it. ... are here, here, and here. See Question&Answers more detail:os...

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

0 votes

413 views

1 answer

sql server - From .NET can I get the full SQL string generated by a SqlCommand object (with SQL Parameters)?

From the .NET environment can I get access to the full SQL string that is generated by a SqlCommand object? ... lend credence to the answers. See Question&Answers more detail:os...

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

0 votes

390 views

1 answer

sql server - Constraints check: TRY/CATCH vs Exists()

I have a table with unique constraint on it: create table dbo.MyTab ( MyTabID int primary key identity, ... happens through Update statement). See Question&Answers more detail:os...

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

0 votes

555 views

1 answer

sql server - Multiple rows into a single row and combine column SQL

I am trying to make this view query two tables and then roll up each Program ID into one row ... BY dbo.tblProgramAttributes.ProgramID DESC See Question&Answers more detail:os...

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

0 votes

400 views

1 answer

sql - Why does NVL always evaluate 2nd parameter

Does anyone know, why Oracle's NVL (and NVL2) function always evaluate the second parameter, even if the first ... first parameter is not NULL. See Question&Answers more detail:os...

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

0 votes

503 views

1 answer

sql - How can I count the number of words in a string in Oracle?

I'm trying to count how many words there are in a string in SQL. Select ("Hello To Oracle") from dual; ... be more than one space between words. See Question&Answers more detail:os...

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

0 votes

362 views

1 answer

sql server 2008 - What are the Pros and Cons of Cascading delete and updates?

Maybe this is sort of a naive question...but I think that we should always have cascading deletes and updates ... deletes and updates ? Thanks. See Question&Answers more detail:os...

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

0 votes

721 views

1 answer

sql - Operand data type time is invalid for avg operator...?

How can I avg(time(4)) in the following query: select top 10 avg(e.Duration) from TimeTable e I'm getting the ... ------- 00:00:10.0000 See Question&Answers more detail:os...

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

0 votes

346 views

1 answer

sql server - How to Substitute a String if record is NULL in T-SQL

I'm writing a T-SQL report that shows the number of accounts that are in different statuses for different ... an easy question to answer. See Question&Answers more detail:os...

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

0 votes

341 views

1 answer

sql server - JDBC connection string with instance name and domain

I have a database created in SQL Server with the following configuration: Also, I am trying to connect ... e812971f-b03c-4210-9dbd-de0791bcc304 See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags