Recent questions tagged SQL

0 votes

1.4k views

1 answer

sql - How to return only 1 row if multiple duplicate rows and still return rows that are not duplicates?

I have a temptable that looks like this: RequestID | CreatedDate | HistoryStatus CF-0000001 | 8/26/2009 1:07: ... rows that are not duplicates? See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

sql - Comparing date with sysdate in oracle

I have a column which is of "DATE" type and I want to run a query on it comparing it with sysdate. ... was found where a numeric was expected 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 ce - Should I call "SqlCeEngine.Upgrade()" when both the SDF file and the device are seemingly the same version (2)?

This is a followup to a question here ctacke said there regarding SQL Server CE-related "issues" I was/ ... Size = 403KB C:Program Files (x86)Microsoft.NETSDKCompactFrameworkv2.0D...

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

0 votes

1.2k views

1 answer

sql - How to find specific VALUE to specific STRING location in different strings

I have a sting like this ,x,x,y,x,x,O,x,y that matches to its values in an other sting like this 0~1~b~~z~XY~1 ... ~1~b~~z~XY~1~7 O=1 Thank you. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql - I have a delete-insert CTE that fails in a strange manner

This is an example of it succeeding: with x as ( delete from common.companies where id = '0f8ed160-370a- ... is the only functional difference. See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

sql - associative array in vba like php

I need your help for building analytics in Microsoft Excel using VBA. I have one data sheet with y columns ... but without success. Any idea? 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 we figure out that a column in my oracle table is being populated/updated by a trigger of another table?

Consider a scenario, where there are two tables "A" and "B". Table "A" has a trigger "Ta" [written long ... educating me on this. Regards a.b See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - DATENAME(MONTH,GETADATE()) is returning numeric value of the month as '09'

When I run the following query [SELECT DATENAME(MONTH,GETDATE())], ideally speaking it should return value as ' ... 42 Operating System 5.2.3790 See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql - Convert DATETIME to Unix Epoch in Informix

I have a DATETIME column: SELECT mytime FROM mytable; mytime -------------------- 1/6/2013 10:41: ... but no luck. This is Informix database. See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

sql - inverse row to column

I have a larger SQL that produces a similar output as this simplified example: SELECT 5 AS L0, 2 AS L1, 3 ... inversion from a row to column. 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 - SQL query: how to create subtotal rows when there is no aggregate function

Is there a function in SQL that can display subtotal rows. I have a table like this: Date INVNUNBER CUSTOMER ITEM ... each, can SQL do this? See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql - modify(replace) XML for conditions

I want to replace the value in an element tag, depending on its value, as well as the value of another ... DataType is "Float". -Thankyou 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 I write a query to extract individual changes from snapshots of data?

I need to create a process that will extract the changes from a table where each row is a snapshot of a row ... . Thanks much for any advice. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql - Oracle-XMLTYPE : How to update a value

I have an Oracle table with a xmltype column that stores XML in the following format <?xml version="1.0" encoding ... from "floor" to "SALES" See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - Oracle (11.2.0.1) : How to identify the row which is currently updated by the UPDATE statement

My table contains around 1 Billion Records. My UPDATE statement took more time to update the huge volume of ... rows are updated currently? See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

sql server - Get number of weekends between two dates in SQL

I need to get the number of weekends between dates in sql as a function. I have tried but stuck up ... @dFrom) End Return (@weekends) END 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 - Strange intermittent SQL connection error, fixes on reboot, comes back after 3-5 days (ASP.NET)

For some reason every 3-5 days our web app loses the ability to open a connection to the db with the following ... .NET Version:2.0.50727.3053 See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql order by - avoid Sorting by the MYSQL IN Keyword

When querying the db for a set of ids, mysql doesnot provide the results in the order by which the ids were ... can i avoid this auto sorting See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

sql - Update an excel sheet using VBA/ADO

When I execute this function I get a run time error, "Operation must use an updateable query". What is ... Set cnn = Nothing End Function See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

sql server 2008 - Stored procedure with table name as parameter

I have a stored procedure, and I would like to assign the number of rows of that table to a variable and ... would I assign the variable @Nval? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql - Derby's handling of NULL values

I am new to Derby and I noticed that I face similar problems as when using the DB2 RDBMS as far as null ... any of these RDBMS? Derby DB2 See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql - Returning the value of identity column after insertion in Oracle

How do I return the value of an identity column (id) in Oracle 12c after insertion? Seems like most of the ... the id of the inserted item. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql server - How to parse a string and create several columns from it?

I have a varchar(max) field containing Name Value pairs, in every line I have Name UnderScore Value. I ... Value1 Name2 Value2 Name3 Value3 See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql - Performance considerations for temporary data in Oracle

I'm evaluating various options to run a bunch of high-performing queries against a single temporary data set ... comparing the various options? See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

sql server - PHP 7.0 ODBC-Driver for Windows

I upgraded my PHP 5.6.30 (https://www.apachefriends.org/de/download.html) to PHP 7.0 (https://bitnami. ... fixed it? Thank und Greeting Domi See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - Parsing OpenXML with multiple elements of the same name

I have a data structure as such: <rootnode> <group> <id>1</id> <anothernode>first string</anothernode> < ... third string 2 | fourth string 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 2005 - Can you do a select on the results of a stored procedure in T-SQL

select * from (EXEC sp_SomeStoredProc) If you can't do this then what is stopping it from being added to the SQL standard or T-SQL? 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 use a function-based index on a column that contains NULLs in Oracle 10+?

Lets just say you have a table in Oracle: CREATE TABLE person ( id NUMBER PRIMARY KEY, given_names VARCHAR2(50 ... index on UPPER(last_name)? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags