Recent questions tagged sql

0 votes

1.3k views

1 answer

sql server - How to open a rpt file as a SQL Table?

I have a rpt dump that one of my colleagues gave. I need to open this file as a SQL Table (I presume that ... file as a separate file in SSMS. See Question&Answers more detail:os...

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

0 votes

984 views

1 answer

sql server - How do I find the maximum database space and the used database space in SQL Azure?

In SQL Azure each database has a size limitation (adjustable). In order for my service to not suddenly come to ... in a SQL Azure database? See Question&Answers more detail:os...

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

0 votes

879 views

1 answer

sql - Complex Postgres query

I have a db schema like following - (Country table) | Country | Country Code| ------------------ ... a query to implement this logic? Thanks See Question&Answers more detail:os...

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

0 votes

759 views

1 answer

sql - Pass multiple sets or arrays of values to a function

I'm writing a PL/pgSQL function in PostgreSQL 9.3.10 to return who has attended certain classes/sessions from the ... there any way to fix this? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - Update xml tag in a CLOB column in Oracle

I have this xml value in a CLOB column in Oracle 11g: <Energy xmlns="http://euroconsumers.org/ ... of InsertDate? Thanks in advances See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - Sum of data in varchar column

i have to sum element in a column(SCENARIO1) that is varchar and contain data like (1,920, 270.00, 0 ... code_pere='00000000' any help please See Question&Answers more detail:os...

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

0 votes

807 views

1 answer

sql - FOREIGN KEY SAME TABLE error - but foreign key doesn't exist

I am trying to add a foreign key constraint which references the same table. IF NOT EXISTS (SELECT * FROM sys. ... dbo.Documents", column 'Id'. See Question&Answers more detail:os...

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

0 votes

980 views

1 answer

sql - this php code works in localhost but not on server?

we are making an collage project that is about to store website name , category , and details so we are done ... file or directory Thank You . See Question&Answers more detail:os...

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

0 votes

858 views

1 answer

sql - How to update ms access database table using update and sum() function?

I have Two tables in my access database table1(ID,productname,qunatity,remainder) table2(ID,productname,sales) these ... ) from second table" See Question&Answers more detail:os...

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

0 votes

962 views

1 answer

sql server - How to run SQL statement from Databricks cluster

I have an Azure Databricks cluster that processes various tables and then as a final step I push these table into an ... >= '01/01/2019' See Question&Answers more detail:os...

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

0 votes

882 views

1 answer

sql - MySQL, passing a AUTO_INCREMENT to another table

Since the other one was answered correctly and i got a new idea for solving my problem (that's not really like the case ... 'en', 'best of XX'); See Question&Answers more detail:os...

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

0 votes

870 views

1 answer

sql - Date without the time

I'm working with SQL Server 2005. I have a column called purchase_time of type datetime. How do I select ... is this format locale dependant? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql - How to update Oracle Clob by using JDBC

Normal way looks like this: pStmt = conn.prepareStatement("SELECT DETAILS FROM PROGRAM_HISTORY WHERE id = 12"); ... . just like update varchar. See Question&Answers more detail:os...

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

0 votes

852 views

1 answer

sql - MySql select dynamic row values as column names

This is my given table: +---------+------------+-------------------+------------ ... there a way to achieve this without temp table and views? See Question&Answers more detail:os...

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

0 votes

787 views

1 answer

sql server - For a composite foreign key, is a/why is a composite UNIQUE constraint in the referenced table required for a column combination with a primary key?

I have a question regarding explicitly defining of the uniqueness of something. This relates to the creation of a ... am I missing something? See Question&Answers more detail:os...

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

0 votes

815 views

1 answer

sql server 2008 - Sql Case statement within Sql IN

I have a sql statement which have a where condition like below WHERE (TABLE1.Field=@Id OR (@Id=0)) This works fine ... @Id ELSE (6,16,18) END) See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - Column Ambiguously Defined

I'm getting: ORA-00918: column ambiguously defined 00918. 00000 - "column ambiguously defined" Whenever I try ... ssl.employee_id; Any ideas? See Question&Answers more detail:os...

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

0 votes

801 views

1 answer

sql - Fewest number of buckets to bag elements in bigquery

I have a matrix with buckets and elements like below. If an element can fit in a bucket it is 1 in the ... , 1 as bucketd, 1 as buckete See Question&Answers more detail:os...

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

0 votes

724 views

1 answer

sql - Convert unknown number of comma separated varchars within 1 column into multiple columns

Let me say upfront that I'm a brand-spanking-new SQL Developer. I've researched this and haven't been able ... in advance for any help everyone! See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql server - SSIS process for saving .xlsx file as .csv file

I am trying to download a .xlsx excel file from FTP server and save it in a .csv file format. I was able ... 't work. can someone please help. See Question&Answers more detail:os...

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

0 votes

942 views

1 answer

sql - Access 2007: "SELECT COUNT(DISTINCT ..."

I have a table that contains a StudyId, a PatientId, and a StudyStartDateTime. I'd like to graph the totals ... help would be very appreciated. 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 - Resolve hostnames with t-sql

How can i resolve a hostname in t-sql? a 2000 compatible method is preferred. Although something that works on 2005 ... to return 69.59.196.211 See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql - Syntax error (missing operator) in query expression

I have the following SQL Statement that works fine in SQL Server but in Access gets me an error 'ERM_HAZARD.[ ... SQL Size problem? Any ideas? See Question&Answers more detail:os...

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

0 votes

929 views

1 answer

sql - Trigger in mysql causing error

What is the error in the following code. I am executing in mysql CREATE TRIGGER tg_order_insert BEFORE INSERT ON `order` ... .... and END; line See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - ORACLE unpivot columns to rows

ORACLE 10 Hi, I was reading several posts here and i did not come up to a simple solution I have this data ... like pivot/unpivot in oracle 10. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql server - how to subtract adjacent columns in an ssrs matrix

I have an ssrs matrix which looks like the one below : Month(Columns) Product(Rows) Sales(Data) The output looks ... hide the wide space too ? See Question&Answers more detail:os...

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

0 votes

860 views

1 answer

sql - How to avoid "table mutating" errors

I have an trigger that needs to read from a table after deleting a row. Essentially, I need to count up the ... .Di_Patient; END IF; END; / See Question&Answers more detail:os...

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

0 votes

767 views

1 answer

sql - How can I select the set of rows where each item has the greatest timestamp?

Using Sqlite, I'd like to fetch the collection of rows each with the greatest timestamp. The table contains ... why I'd appreciate assistance. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags