Recent questions tagged sql

0 votes

843 views

1 answer

sql - Oracle- Split string comma delimited (string contains spaces and consecutive commas)

I can't find a solution about how to split a comma-delimited string in ORACLE. Searched a lot, nothing works for ... value is out of order!!!! See Question&Answers more detail:os...

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

0 votes

507 views

1 answer

sql server - comparing a column to a list of values in t-sql

I am displaying records on a page, and I need a way for the user to select a subset of those records ... . anyone else have any suggestions? See Question&Answers more detail:os...

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

0 votes

522 views

1 answer

sql server - Save a spark RDD to the local file system using Java

I have a RDD that is generated using Spark. Now if I write this RDD to a csv file, I am provided with ... Any clarity needed, please let know. See Question&Answers more detail:os...

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

0 votes

630 views

1 answer

sql - How do I create a decimal field in Access with Alter Table?

I want to programmatically create a new column in an MS Access table. I've tried many permutations of ALTER TABLE ... . I am using Access 2003. See Question&Answers more detail:os...

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

0 votes

617 views

1 answer

sql server 2008 - How can I get a trigger to fire on each inserted row during an INSERT INTO Table (etc) SELECT * FROM Table2?

I've been trying to avoid using a cursor in this particular case just because I dislike the tradeoffs, and it ... @Subject, @body='//etc' END See Question&Answers more detail:os...

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

0 votes

653 views

1 answer

sql server - SQL to find first non-numeric character in a string

I inherited a table with identifiers in a format [nonnumericprefix][number]. For example (ABC123; R2D2456778; etc). I ... I'd post it here. See Question&Answers more detail:os...

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

0 votes

623 views

1 answer

sql server - How do I connect to a MSSQL database using Perl's DBI module in Windows?

How do I connect to a MSSQL database using Perl's DBI module in Windows? See Question&Answers more detail:os...

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

0 votes

801 views

1 answer

sql - How to pivot dynamically with date as column

I have a table with product id's and names, and another table with the stock of these products on certain dates. Such as ... | 2 | 2 | 4-1-2014 See Question&Answers more detail:os...

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

0 votes

669 views

1 answer

sql - Convert String to Date in MS Access Query

I am trying to retrieve data from my access table based on Date column. My requirement is to display everything greater ... How can I fix this ? See Question&Answers more detail:os...

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

0 votes

617 views

1 answer

sql order by - Mysql delete statement with limit

I'm trying to delete rows from a table but I get an error. DELETE FROM `chat_messages` ORDER BY `timestamp` DESC ... 1 No idea what's wrong. See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql - Produce DISTINCT values in STRING_AGG

I'm using the STRING_AGG function in SQL Server 2017. I'd like to create the same effect as COUNT(DISTINCT ... my example is much simpler. See Question&Answers more detail:os...

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

0 votes

549 views

1 answer

sql - Oracle DB quote column names

When using regular tables, its fine to use the following Oracle SQL query: SELECT max(some_primary_key) FROM MyTable ... , but not with Tables? See Question&Answers more detail:os...

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

0 votes

501 views

1 answer

sql - Does assigning stored procedure input parameters to local variables help optimize the query?

I have a stored procedure that takes 5 input parameters. The procedure is a bit complicated and takes around 2 minutes ... so, how does it help? See Question&Answers more detail:os...

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

0 votes

619 views

1 answer

sql - how to transform comma separated column into multiples rows in db2

I have the following table (the number of the references is variable): Id | FK_ID| Reference | --------- ... the data like this using DB2? See Question&Answers more detail:os...

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

0 votes

551 views

1 answer

sql server - In tsql is an Insert with a Select statement safe in terms of concurrency?

In my answer to this SO question I suggest using a single insert statement, with a select that increments a ... version numbers. Am I correct? See Question&Answers more detail:os...

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

0 votes

872 views

1 answer

sql - How do I call an Oracle stored procedure from an Excel VBA script?

I have a stored procedure with parameters in an Oracle database. How do I call it from within an Excel VBA script? See Question&Answers more detail:os...

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

0 votes

780 views

1 answer

sql - Parallel unnest() and sort order in PostgreSQL

I understand that using SELECT unnest(ARRAY[5,3,9]) as id without an ORDER BY clause, the order of the result ... I am using PostgreSQL 9.3.3. See Question&Answers more detail:os...

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

0 votes

596 views

1 answer

sql - mysql select id and name from other table and join query

i have 2 table named projects and tasks in projects table i have: id name --------- 1 some in tasks ... by 'project_id' in table tasks? thanks See Question&Answers more detail:os...

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

0 votes

670 views

1 answer

sql server - Get SQL xml attribute value using variable

I have a SQL function that takes a variable called attribute, which is the xml attribute I want to get the ... there another way to do this? See Question&Answers more detail:os...

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

0 votes

579 views

1 answer

sql server - Convert from DateTime to INT

In my SSIS package, I have to converting values from DateTime to a corresponding INTEGER value. The following sample ... 40299 6/1/2010 40330 See Question&Answers more detail:os...

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

0 votes

576 views

1 answer

sql - GROUP_CONCAT in SQLite

I am having data like this 1 A 1 B 1 C 1 D 2 E 2 F 3 G 3 H 3 I 3 J 3 K by using this ... here. What are the right procedure to achieve that? See Question&Answers more detail:os...

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

0 votes

596 views

1 answer

sql - MySql using correct syntax for the over clause

What is the correct syntax to get the over clause to work in mysql? I would like to see the total sms ... , userTable WHERE userId = sentUserId; See Question&Answers more detail:os...

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

0 votes

690 views

1 answer

sql - Count Returning blank instead of 0

Good day everyone. Here is my code: SELECT 'Expired Item -'+ DateName(mm,DATEADD(MM,4,AE.fld_LOAN)) as [Month ... know what's wrong. Thank you. See Question&Answers more detail:os...

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

0 votes

640 views

1 answer

sql - How can I make an average of dates in MySQL?

How can I make an average between dates in MySQL? I am more interested in the time values, hours and minutes ... clue what data it is returning. See Question&Answers more detail:os...

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

0 votes

665 views

1 answer

sql server - Which is quicker COALESCE OR ISNULL?

I understand the difference between these functions but my question is when checking for a single null value would ... FROM SomeTable, 0) See Question&Answers more detail:os...

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

0 votes

646 views

1 answer

sql - PLSQL Insert into with subquery and returning clause

I can't figure out the correct syntax for the following pseudo-sql: INSERT INTO some_table (column1, column2) ... . Is there an alternative? See Question&Answers more detail:os...

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

0 votes

595 views

1 answer

sql server - SQL update top1 row query

The query below is working: update top(1) ShipBillInfo set shipfirstname='kkk' where CustomerId='134'; but it ... 134' order by OredrGUID desc; See Question&Answers more detail:os...

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

0 votes

533 views

1 answer

sql server - Unable to find the requested .Net Framework Data Provider. It may not be installed. - when following mvc3 asp.net tutorial

I am following the ASP.NET MVC 3 Music store application tutorial but I keep getting stuck in part 4: ... guidance would be really appreciated See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags