Recent questions tagged SQL

0 votes

247 views

1 answer

sql - Extract phone number from noised string

I have a column in a table that contains random data along with phone numbers in different formats. The column ... ) Standard Edition (64-bit) See Question&Answers more detail:os...

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

0 votes

351 views

1 answer

sql - How do I calculate a moving average using MySQL?

I need to do something like: SELECT value_column1 FROM table1 WHERE datetime_column1 >= '2009-01-01 00:00: ... MySQL extensions if necessary. See Question&Answers more detail:os...

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

0 votes

369 views

1 answer

sql server - BULK INSERT with inconsistent number of columns

I am trying to load a large amount data in SQL server from a flat file using BULK INSERT. However, my ... KEEPNULLS, FIELDTERMINATOR = '#' ) See Question&Answers more detail:os...

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

0 votes

301 views

1 answer

sql - Efficient way to string split using CTE

I have a table that looks like ID Layout 1 hello,world,welcome,to,tsql 2 welcome,to,stackoverflow The desired ... query but using CTE only. See Question&Answers more detail:os...

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

0 votes

352 views

1 answer

sql server - TSQL Calculate week number of the month

I want to calculate the week number of the month,I want to calculate the week number whether its odd or even week ... this in TSQL ? Thanks all! See Question&Answers more detail:os...

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

0 votes

268 views

1 answer

sql server - SHA-256 hashes different between C# and Javascript

I am currently working on a project that will involve credit card swipes for admissions based on database rows. Like ... /i.imgur.com/raEyX.png See Question&Answers more detail:os...

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

0 votes

668 views

1 answer

sql server - Converting NVARCHAR(255) to DATE

I'm trying to transfer some old SQL Server data using Excel into SQL Server. It seems that ... myTable ALTER COLUMN columnName SMALLDATETIME See Question&Answers more detail:os...

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

0 votes

370 views

1 answer

sql server - Do I have to close the SQL Connection manually if I use Linq?

Traditionally, when we use SQL string to done some work, we have to close the sql connection before the ... to close the connection manually? See Question&Answers more detail:os...

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

0 votes

460 views

1 answer

sql server - How to get entire VARCHAR(MAX) column with Python pypyodbc

I have a Python program that connects to an MSSQL database using an ODBC connection. The Python library I'm using ... using MAX won't work. See Question&Answers more detail:os...

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

0 votes

352 views

1 answer

sql - PostgreSQL: top n entries per item in same table

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

0 votes

315 views

1 answer

sql server - How do I split flat file data and load into parent-child tables in database?

I have denormalized data (coming from a file) that needs to be imported into parent-child tables. The source data ... in the language of SSIS. See Question&Answers more detail:os...

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

0 votes

383 views

1 answer

sql - Spring Boot Query annotation with nativeQuery doesn't work in Postgresql

Development environment. OS: windows 8 IDE : Eclipse Luna with JAVA 8 Postgresql : 9.3.4 in OPENBSD 5.5 ... Domain Object] process. Please help~ See Question&Answers more detail:os...

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

0 votes

290 views

1 answer

sql - Number of fridays between two dates

How do I find the number of fridays between two dates(including both the dates) using a select statement in oracle sql? See Question&Answers more detail:os...

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

0 votes

477 views

1 answer

sql - Postgresql select until certain total amount is reached

I was wondering if I could get any help with the following problem. I have a table of transactions (simplified ... be much appreciated :) T See Question&Answers more detail:os...

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

0 votes

498 views

1 answer

sql server - SQL Get "ISO Year" for ISO Week

I need to calculate the year a week is assigned to. For example the 29th december of 2003 was assigned to week one ... , that would be nice :-) See Question&Answers more detail:os...

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

0 votes

272 views

1 answer

sql - How to combine two rows and calculate the time difference between two timestamp values in MySQL?

I have a situation that I'm sure is quite common and it's really bothering me that I can't figure out how to do ... I can't seem to find them... See Question&Answers more detail:os...

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

0 votes

194 views

1 answer

sql server - How can I structure a query to give me only the rows that match ALL values in a CSV list of IDs in T-SQL

I've created a simple example (hopefully much more fun than my actual data) to better express my question: ... based on delimiter passed in. See Question&Answers more detail:os...

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

0 votes

275 views

1 answer

sql server - TooManyRowsAffectedException with encrypted triggers

I'm using nHibernate to update 2 columns in a table that has 3 encrypted triggers on it. The triggers are not ... , but it doesn't crater. See Question&Answers more detail:os...

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

0 votes

409 views

1 answer

sql - Calling a function that returns a refcursor

I am using Postgresql 8.3 and have the following simple function that will return a refcursor to the client ... the generated cursor name ? See Question&Answers more detail:os...

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

0 votes

344 views

1 answer

sql server - Does wrapping nullable columns in ISNULL cause table scans?

Code analysis rule SR0007 for Visual Studio 2010 database projects states that: You should explicitly indicate how to ... in a table scan? See Question&Answers more detail:os...

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

0 votes

380 views

1 answer

sql - How to return the table using mysql Function

I am using MySQL. I want to return the table using MySQL function. In SQL its working fine but not in MySQL. ... values('raja') return END; $$ See Question&Answers more detail:os...

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

0 votes

267 views

1 answer

sql - Database normalization - who's right?

My professor(who claimed to have a firm understanding about systems development for many years) and I are arguing ... tell me what you think. See Question&Answers more detail:os...

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

0 votes

380 views

1 answer

sql - mysql query to update field to max(field) + 1

What I want to do is: UPDATE table SET field = MAX(field) + 1 WHERE id IN (1, 3, 5, 6, 8); The ... to get the outcome I desire? Regards, Vic See Question&Answers more detail:os...

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

0 votes

210 views

1 answer

sql - How to find out whether a table has some unique columns

I use MS SQL Server. Ive been handed some large tables with no constrains on them, no keys no nothing. I ... or build-in function. Thanks. See Question&Answers more detail:os...

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

0 votes

589 views

1 answer

sql - #1366 - Incorrect integer value:MYsql

hi every one i have a problem in mysql my table is CREATE TABLE IF NOT EXISTS `contactform` ( `contact_id` ... machine but give error on server See Question&Answers more detail:os...

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

0 votes

391 views

1 answer

sql server - What is the scope of SET IDENTITY_INSERT xyz ON?

What is the scope of SET IDENTITY_INSERT xyz ON? If I use this in one stored procedure for a certain table, ... tables at the same time? See Question&Answers more detail:os...

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

0 votes

439 views

1 answer

sql - How to change date format in hive?

My table in hive has a filed of date in the format of '2016/06/01'. but i find that it is not in ... so that them can compare. Many thanks. See Question&Answers more detail:os...

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

0 votes

398 views

1 answer

sql server - SQL Find difference between previous and current row

I am trying to find the difference between the current row and the previous row. However, I am getting the following error ... a.ROW = b.ROW + 1 See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags