Questions - QStack.ai

11

views

1

answer

1

vote

2022-07-05 07:00:00 +0000 lalupa

How can a column be altered based on conditions, with the possibility of creating a new column?

sql
sed

10

views

1

answer

2

votes

2022-07-04 11:00:00 +0000 bukephalos

Why does the Spring Data JPA Auditing fail to work on the update method in the JpaRepository that uses the @Modifying annotation?

sql

12

views

1

answer

3

votes

2022-07-04 01:00:00 +0000 lakamha

Due to SyntaxError, why am I unable to create a TIMESTAMP WITH TIMEZONE column in postgres?

9

views

1

answer

1

vote

2022-06-29 03:00:00 +0000 ladyg

The output of queries executed through Pyodbc and SQL Server differs, can you explain why?

sed
sql

1

view

1

answer

1

vote

2022-06-25 22:00:00 +0000 lalupa

While moving to AWS and upgrading Postgres, why is the authentication method 10 not supported resulting in SQLSTATE[08006] [7]?

sql

1

view

1

answer

3

votes

2022-06-25 02:00:00 +0000 lalupa

How can we enable the use of both DateTime and DateTimeOffset columns within a single model/context?

sql

12

views

1

answer

4

votes

2022-06-25 01:00:00 +0000 djk

How can PrestoDB or Hive be utilized to access Netapp StorageGrid?

sed
sql

11

views

1

answer

4

votes

2022-06-24 20:00:00 +0000 lakamha

What causes the slow performance of updating via join in MySQL?

1

view

1

answer

3

votes

2022-06-23 19:00:00 +0000 ladyg

What is the problem encountered when attempting to register a Microsoft.Data.SqlClient.SqlClientFactory.Instance with DbProviderFactories?

sql

13

views

1

answer

4

votes

2022-06-23 04:00:00 +0000 lalupa

How to perform insert and select operations using Knex in a similar manner to SQL?

13

views

1

answer

3

votes

2022-06-20 10:00:00 +0000 nofretete

What is the T-SQL query to obtain the name and state (Primary or Secondary) of a Windows Server Failover Cluster node?

t-sql
sql

10

views

1

answer

4

votes

2022-06-20 00:00:00 +0000 lakamha

How to query the Firebase Auth table in FireStore?

sql

1

view

1

answer

2

votes

2022-06-17 12:00:00 +0000 lalupa

How can one automate the process of exporting SQL data using Dbeaver?

sql

8

views

1

answer

4

votes

2022-06-17 00:00:00 +0000 woof

How to retrieve rows using Sequelize that have at least one many-to-many item?

sql
sed

10

views

1

answer

3

votes

2022-06-15 03:00:00 +0000 plato

What is the usage of the LEAD window function in EF Core 3.1 PostgreSQL?

12

views

1

answer

3

votes

2022-06-15 02:00:00 +0000 woof

What are the databases available in PostgreSQL when using SQLAlchemy?

1

view

1

answer

no

votes

2022-06-14 00:00:00 +0000 pufferfish

Can you pivot two groups in SQL?

sql

10

views

1

answer

no

votes

2022-06-13 14:00:00 +0000 woof

What is the process for establishing a connection between an Oracle database and a SQL Server database?

16

views

1

answer

4

votes

2022-06-13 12:00:00 +0000 lakamha

How can table name be passed as an argument in psycopg2?

sql
sed

1

view

1

answer

no

votes

2022-06-12 20:00:00 +0000 nofretete

In SQL, how do I create a table with several identifiers that have distinct responses, and then merge them into a single row?

sql

19

views

1

answer

3

votes

2022-06-12 12:00:00 +0000 woof

What is the method to retrieve the JSON data from a column in SQL?

1

view

1

answer

2

votes

2022-06-11 16:00:00 +0000 huitzilopochtli

Why does a comparison with a NULL date result in a NULL value in SQL Server?

sql

16

views

1

answer

4

votes

2022-06-11 15:00:00 +0000 ladyg

How can operations be performed on the return value of a function in Oracle PLSQL?

7

views

1

answer

3

votes

2022-06-11 06:00:00 +0000 lalupa

What is the meaning of the error message "ORA-00902: invalid datatype" when attempting to combine nested tables?

sed
sql

1

view

1

answer

2

votes

2022-06-10 18:00:00 +0000 ladyg

What does the PL/pgSQL function error message "workspace_id column reference is ambiguous" indicate?

sql

9

views

1

answer

no

votes

2022-06-10 13:00:00 +0000 qstack

What is the process of determining the time difference in PostgreSQL using jSON data?

15

views

1

answer

2

votes

2022-06-08 19:00:00 +0000 woof

How can the issue of null values in API PUT data request be resolved when updating the MySQL database?

18

views

1

answer

1

vote

2022-06-05 13:00:00 +0000 djk

How can SQL/PLSQL blocks be stripped of their comments?

python
sql

9

views

1

answer

3

votes

2022-06-05 11:00:00 +0000 huitzilopochtli

How to use Spark BQ Connector in Dataproc to add labels to a Big Query table from a Pyspark job?

sql

8

views

1

answer

3

votes

2022-06-03 10:00:00 +0000 ladyg

How can Spring batch save the last n values from a CSV file to the last column in a database?

sql

1122 questions

How can a column be altered based on conditions, with the possibility of creating a new column?

Why does the Spring Data JPA Auditing fail to work on the update method in the JpaRepository that uses the @Modifying annotation?

Due to SyntaxError, why am I unable to create a TIMESTAMP WITH TIMEZONE column in postgres?

The output of queries executed through Pyodbc and SQL Server differs, can you explain why?

While moving to AWS and upgrading Postgres, why is the authentication method 10 not supported resulting in SQLSTATE[08006] [7]?

How can we enable the use of both DateTime and DateTimeOffset columns within a single model/context?

How can PrestoDB or Hive be utilized to access Netapp StorageGrid?

What causes the slow performance of updating via join in MySQL?

What is the problem encountered when attempting to register a Microsoft.Data.SqlClient.SqlClientFactory.Instance with DbProviderFactories?

How to perform insert and select operations using Knex in a similar manner to SQL?

What is the T-SQL query to obtain the name and state (Primary or Secondary) of a Windows Server Failover Cluster node?

How to query the Firebase Auth table in FireStore?

How can one automate the process of exporting SQL data using Dbeaver?

How to retrieve rows using Sequelize that have at least one many-to-many item?

What is the usage of the LEAD window function in EF Core 3.1 PostgreSQL?

What are the databases available in PostgreSQL when using SQLAlchemy?

Can you pivot two groups in SQL?

What is the process for establishing a connection between an Oracle database and a SQL Server database?

How can table name be passed as an argument in psycopg2?

In SQL, how do I create a table with several identifiers that have distinct responses, and then merge them into a single row?

What is the method to retrieve the JSON data from a column in SQL?

Why does a comparison with a NULL date result in a NULL value in SQL Server?

How can operations be performed on the return value of a function in Oracle PLSQL?

What is the meaning of the error message "ORA-00902: invalid datatype" when attempting to combine nested tables?

What does the PL/pgSQL function error message "workspace_id column reference is ambiguous" indicate?

What is the process of determining the time difference in PostgreSQL using jSON data?

How can the issue of null values in API PUT data request be resolved when updating the MySQL database?

How can SQL/PLSQL blocks be stripped of their comments?

How to use Spark BQ Connector in Dataproc to add labels to a Big Query table from a Pyspark job?

How can Spring batch save the last n values from a CSV file to the last column in a database?

Contributors

Tags