Recent questions tagged SQL

0 votes

458 views

1 answer

sql server 2005 - Best way to interpolate values in SQL

I have a table with rate at certain date : Rates Id | Date | Rate ----+---------------+------- 1 ... to be done in a programmatic way (C#...) ? See Question&Answers more detail:os...

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

0 votes

422 views

1 answer

sql - MySQL: how to drop multiple tables using single query?

I want to drop multiple tables with ease without actually listing the table names in the drop query and the tables ... have prefix say 'wp_' See Question&Answers more detail:os...

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

0 votes

733 views

1 answer

sql - PostgreSQL with-delete "relation does not exists"

I am using postgreSQL 9.1 and I want to delete duplicates from my table using this tip: https://stackoverflow.com/ ... to get it work? Thanks! See Question&Answers more detail:os...

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

0 votes

330 views

1 answer

sql - PostgreSQL copy/transfer data from one database to another

I need to copy data from one table to another. the two tables have almost the same structure, but are in ... cross database ... not implemented See Question&Answers more detail:os...

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

0 votes

379 views

1 answer

sql server 2008 - Recursive select in SQL

I have an issue I just can't get my head around. I know what I want, just simply can't get it out on the ... so I appreciate all help I can get. See Question&Answers more detail:os...

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

0 votes

579 views

1 answer

sql server - How to return temporary table from stored procedure

CREATE PROCEDURE [test].[proc] @ConfiguredContentId int, @NumberOfGames int AS BEGIN SET NOCOUNT ON RETURN @WunNumbers TABLE ... . Any ideas??? See Question&Answers more detail:os...

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

0 votes

436 views

1 answer

sql server - Need to generate n rows based on a value in a column

I have the following table TABLE A ID | QUANTITY ------------ 1 | 3 2 | 2 What I need is TABLE ... UDFs but is there a more graceful solution? See Question&Answers more detail:os...

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

0 votes

393 views

1 answer

sql server - Multiple aggregate functions in one SQL query from the same table using different conditions

I'm working on creating a SQL query that will pull records from a table based on the value of two ... insight would be greatly appreciated. See Question&Answers more detail:os...

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

0 votes

408 views

1 answer

sql server - Move row from one table to another?

I have two tables with the same column definitions. I need to move (not copy) a row from one table to ... a smarter way? SQL Server 2005 See Question&Answers more detail:os...

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

0 votes

707 views

1 answer

sql server 2005 - Can a SQL trigger call a web service?

I'm building out a RESTful API for an iPhone app. When a user "checks-in" [Inserts new row into a table] ... approach that I haven't thought of. See Question&Answers more detail:os...

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

0 votes

436 views

1 answer

sql - How can I order entries in a UNION without ORDER BY?

How can I be sure that my result set will have a first and b second? It would help me to solve a tricky ... UNION SELECT b FROM B LIMIT 1; See Question&Answers more detail:os...

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

0 votes

418 views

1 answer

sql - How can I do an insert where not exists?

I'd like to combine an insert query with a "where not exists" so as not to violate PK constraints. However, ... an insert with a where clause?) See Question&Answers more detail:os...

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

0 votes

364 views

1 answer

sql - how to query in sqlite for different date format

I am using sqlite for local database in mobile and in my database, I have date field with column name RN_CREATE_DATE ... help me out with this. See Question&Answers more detail:os...

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

0 votes

361 views

1 answer

sql server - SQL design around lack of cross-database foreign key references

For better or worse, we have a solution that relies on multiple databases that all reference a common administration ... smarter than me ... See Question&Answers more detail:os...

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

0 votes

388 views

1 answer

sql - SELECT INTO with more than one attribution

This instruction works: SELECT INTO unsolvedNodes array_agg(DISTINCT idDestination) FROM road WHERE idOrigin = ANY( ... set multiple variables? See Question&Answers more detail:os...

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

0 votes

608 views

1 answer

sql server 2008 - DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0) Can someone explain me this

DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0) Can someone explain me this. See Question&Answers more detail:os...

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

0 votes

403 views

1 answer

sql server - How to find out what table a page lock belongs to

I'm using the sys.dm_tran_locks view to check what areas of my database have locks when we are having ... of which tables are locking? See Question&Answers more detail:os...

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

0 votes

373 views

1 answer

sql - Sqlite binding within string literal

Using sqlite3, if my query is SELECT * FROM table WHERE title LIKE '%x%' It will match strings that contain ... a nicer solution for this? See Question&Answers more detail:os...

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

0 votes

842 views

1 answer

sql server - How do I fix the multiple-step OLE DB operation errors in SSIS?

I'm attempting to make a DTS package to transfer data between two databases on the same server and I'm ... and returned error code 0xC0202025. See Question&Answers more detail:os...

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

0 votes

584 views

1 answer

sql - performance - single join select vs. multiple simple selects

What is better as far as performance goes? See Question&Answers more detail:os...

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

0 votes

362 views

1 answer

sql server - EF: The text data type cannot be selected as DISTINCT because it is not comparable

I get this error because I have a SQL Server table with a column of type "text". The text data type ... : p.PSLanguageStatus }).Distinct(); See Question&Answers more detail:os...

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

0 votes

687 views

1 answer

sql - take vs first performance in Ruby on Rails

This is a question regarding ActiveRecord query methods: first Find the first record (or first N records if a ... than first or vice-versa? See Question&Answers more detail:os...

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

0 votes

526 views

1 answer

sql - Is possible to reuse subqueries?

I'm having some problems trying to perform a query. I have two tables, one with elements information, and another one ... ON a.id = subquery.id See Question&Answers more detail:os...

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

0 votes

587 views

1 answer

sql - PostgreSQL - GROUP BY clause or be used in an aggregate function

I found some topics here on SO, but I still can't find the right setup for my query. This is query, that ... be the right config of the query? See Question&Answers more detail:os...

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

0 votes

644 views

1 answer

sql server - SSIS Data Flow Task hangs on excecution of Pre-excecute phase

I have a Data Flow Task that is hanging on excecution. The flow is simple, makes two queries to different ... Validation Property set to True. See Question&Answers more detail:os...

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

0 votes

415 views

1 answer

sql - PostgreSQL: NOT IN versus EXCEPT performance difference (edited #2)

I have two queries that are functionally identical. One of them performs very well, the other one performs ... Query #2 returns immediately. See Question&Answers more detail:os...

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

0 votes

538 views

1 answer

sql - How to BULK INSERT a file into a *temporary* table where the filename is a variable?

I have some code like this that I use to do a BULK INSERT of a data file into a table, where the data file ... a whole day of your time... See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - Column conflicts with the type of other columns in the unpivot list

Im pivoting sys.[views] into key value pairs to compare with values on another server for consistency testing. Im ... (255),type) AS type See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags