Recent questions tagged SQL

0 votes

344 views

1 answer

sql server - Convert rows to columns in SQL

How can I do the following please? See Question&Answers more detail:os...

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

0 votes

521 views

1 answer

sql - grant create view on Oracle 11g

I use SQL*Plus for school and I use the username Scott. I cannot create views because it says: ORA-01031: ... to get it right. Any help? See Question&Answers more detail:os...

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

0 votes

844 views

1 answer

sql - Oracle show all employees with greater than average salary of their department

I am writing a query to find employees who earn greater than the average salary within their department. I ... avg_sal ORDER BY avg_sal DESC See Question&Answers more detail:os...

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

0 votes

706 views

1 answer

sql update - SSIS - Updating a table with a OLE DB Command

I need to translate the next SQL Query in SSIS: (Each table belong to a different source - SQL Server & ORACLE ... ask, but be polite. Regards See Question&Answers more detail:os...

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

0 votes

337 views

1 answer

sql - how to check column structure in ssis?

I have a table customer in my sql server. Columns Distributer_Code Cust_code cust_name cust_add zip tel dl_number ... or columns are misplaced. See Question&Answers more detail:os...

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

0 votes

367 views

1 answer

sql - Perform JOIN query in google cloud firestore

{ "users":{ "userid_1":{ "following":{ "userid_2":{ "name":"user2" }, "userid_3":{ "name":"user3 ... implementation query in fire-store in node? See Question&Answers more detail:os...

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

0 votes

556 views

1 answer

sql server 2008 - Data Conversion Issue in SSIS package - Text to GUID

I am developing a SSIS package that will open an Excel spreadsheet and import the data into a database table ... resolve the conversion error? See Question&Answers more detail:os...

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

0 votes

470 views

1 answer

sql - instr() function SQLITE for Android?

I wanna do the following on my existing sqlite database on android which is kind a built like that colomns: ... "no such operation" exception. See Question&Answers more detail:os...

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

0 votes

390 views

1 answer

sql server 2005 - Procedure times out from ADO.NET but not in SSMS

I've got a stored procedure that is giving me a SqlException because of a timeout when I run it from code ... the cause of the timeout? See Question&Answers more detail:os...

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

0 votes

531 views

1 answer

sql - Output Inserted.Id AND another field

I have the following query: DECLARE @OutProduct TABLE ( ProductID INT, BulkProductId INT ) INSERT INTO dbo.Products ... using SQL Server 2012. See Question&Answers more detail:os...

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

0 votes

823 views

1 answer

sql - HANA: Split string?

Is there a way to split a string in HANA? Something similar to the equivalent in SQL Server: SELECT * FROM dbo ... ('valueA,valueB', ',') See Question&Answers more detail:os...

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

0 votes

459 views

1 answer

sql - Import error using Openrowset

I am trying to import a column (from .csv file) with numeric and alphanumeric values but when I run the openrowset ... =1 and no change at all. See Question&Answers more detail:os...

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

0 votes

466 views

1 answer

sql order by - Need a sequence number for every row in MySQL query

So I found this great use: SELECT (@row:=@row+1) AS ROW, ID FROM TableA ,(SELECT @row := 0) r ORDER BY ... was given. How can I achieve that? See Question&Answers more detail:os...

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

0 votes

426 views

1 answer

sql - Access: create table if it does not exist

Can you give an MS Access equivalent to MySQL 'CREATE TABLE IF NOT EXISTS ...'? Update Something like this IF ... >) would be suitable as well See Question&Answers more detail:os...

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

0 votes

558 views

1 answer

sql - How to group timestamps into islands (based on arbitrary gap)?

Consider this list of dates as timestamptz: I grouped the dates by hand using colors: every group is separated from ... m trying to do here.) See Question&Answers more detail:os...

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

0 votes

506 views

1 answer

sql - Accessing column alias in postgresql

Having a little bit of trouble understanding how a query alias works in postgresql. I have the following: SELECT ... clause. Can anyone help? See Question&Answers more detail:os...

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

0 votes

504 views

1 answer

sql - Mysql Table Column Cannot Be Null

I have created a table with three columns, Id , Name , Quantity. It appears that when I am trying to insert a ... as a valid value for a column? See Question&Answers more detail:os...

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

0 votes

386 views

1 answer

sql server - IN Operator SQL

I have a table called NUMS with a single column n. And I fill values 1,2,3,4,5,null in it. Now a ... anyone explain in detail what's happening. See Question&Answers more detail:os...

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

0 votes

310 views

1 answer

sql - PIVOTing variable number of rows to columns

I'm currently attempting to PIVOT some rows to columns. The problem is that I don't always know how many rows ... in this example, the groupID? See Question&Answers more detail:os...

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

0 votes

436 views

1 answer

sql - C# local database not updating when using |DataDirectory|

I am using a local database and for some reason when I use |DataDirectory|, the database doesn't update when I ... (); Anyone may know why? See Question&Answers more detail:os...

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

0 votes

369 views

1 answer

sql - Creating a flattened table/view of a hierarchically-defined set of data

I have a table containing hierarchical data. There are currently ~8 levels ... org/working_with_hierarchical_data_in_sql_using_ancestor_tables See Question&Answers more detail:os...

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

0 votes

457 views

1 answer

sql - Find a specific column entry in an unknown table in a database?

I'm aware of this topic ( Find a specific column in an unknown table in a database? ) and my problem is quite ... :-/ ). I this possible? See Question&Answers more detail:os...

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

0 votes

416 views

1 answer

sql server 2005 - Problem with alter then update in try catch with tran using Transact-SQL

Here is some Transact-SQL I am trying to run via sqlcmd (SQL Server 2005). USE PUK; GO BEGIN TRANSACTION; ... would be most appreciated! Rob :) See Question&Answers more detail:os...

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

0 votes

662 views

1 answer

sql - MySQL: Expand date range into new rows

I have a table in MySQL that contains min and max date values for each key: key | minDate | maxDate 1 2011-01-01 2011- ... 3 2011-10-19 ... ... See Question&Answers more detail:os...

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

0 votes

386 views

1 answer

sql - changing format date MySql

i have date type column in MySql. by default MySql date format is YYYY/MM/DD. but actualy i prefer to use ... i change the column date format? See Question&Answers more detail:os...

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

0 votes

323 views

1 answer

sql - How to optimize MySQL query (group and order)

Hey all, I've got a query in need of optimizing. It works but its a dog, performance wise. It reads like this: ... A 259 (NULL) (NULL) YES BTREE See Question&Answers more detail:os...

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

0 votes

761 views

1 answer

sql - I am trying to copy a file, but getting error message

I am new to postgres, probably missing something silly like (the correct name of my directory). Can someone guide ... s copy. SQL state: 42501 See Question&Answers more detail:os...

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

0 votes

383 views

1 answer

sql - Using variables in PLSQL SELECT statement

I have a query that queries on ReportStartDate and ReportEndDate so I thought I would use variables in PLSQL. ... variables in my WHERE clause? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags