Recent questions tagged SQL

0 votes

442 views

1 answer

sql - Is there a way to force Oracle to change a query's plan without using hints?

I have a query using wrong indexes. I can see that with the usage of index there is no easy way for ... Any help would be much appreciated. See Question&Answers more detail:os...

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

0 votes

389 views

1 answer

sql server - Can you create a CLR UDT to allow for a shared Table type across databases?

If I had a SQL statement such as this: CREATE TYPE [dbo].[typeRateLimitVariables] AS TABLE( [vchColumnName] [ ... essentially a UDT "AS TABLE" See Question&Answers more detail:os...

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

0 votes

553 views

1 answer

sql - Stackoverflow's Related Questions

Just wondering how you would go about implementing something similar to stackoverflow'd related questions. Would ... linqtosql method. Cheers! See Question&Answers more detail:os...

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

0 votes

459 views

1 answer

sql server - I need row-level locking

This is an extension to Is it possible to force row level locking in SQL Server?. Here is the use case I ... the problem is with the library. See Question&Answers more detail:os...

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

0 votes

446 views

1 answer

sql - Retrieve aggregates for arbitrary time intervals

This is the query I have so far, to create daily bars: SELECT DISTINCT date_trunc('hour',t) AS date, min(price) ... a nice elegant way to do it. See Question&Answers more detail:os...

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

0 votes

453 views

1 answer

sql - Windowing function in Hive

I am exploring windowing functions in Hive and I am able to understand the functionalities of all the UDFs. ... . Appreciate the help :) See Question&Answers more detail:os...

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

0 votes

432 views

1 answer

sql server 2005 - SQL - Conditional WHERE clause

I have a SQL Server 2005 stored procedure that performs a query. This stored procedure takes in three parameters. ... IF @CityID IS NOT NULL See Question&Answers more detail:os...

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

0 votes

492 views

1 answer

sql - MySQL JOIN / GROUP_CONCAT second table?

So I have this query that works perfectly: SELECT users.*, GROUP_CONCAT(categories.category_name) AS categories FROM ... be awesome! Thanks! See Question&Answers more detail:os...

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

0 votes

470 views

1 answer

sql server - Unicode Data Type in SQL

I'm new to Microsoft SQL. I'm planning to store text in Microsoft SQL server and there will be special ... unicode number (i.e. u0056) See Question&Answers more detail:os...

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

0 votes

384 views

1 answer

sql server - Distributed transactions between MySQL and MSSQL

I've tried for nearly a week now to get distributed transactions working. I've some procedures on MSSQL which ... that XA transactions do work? See Question&Answers more detail:os...

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

0 votes

457 views

1 answer

sql - MySQL multiple insert performance

I have data containing about 30 000 records. And I need to insert this data into MySQL table. I group this ... with size about 1KB. Thanks. See Question&Answers more detail:os...

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

0 votes

564 views

1 answer

sql - Table Valued Function where did my query plan go?

I've just wrapped a complex SQL Statement in a Table-valued function on SQLServer 2000. When looking at the Query ... Can I see the true plan? See Question&Answers more detail:os...

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

0 votes

321 views

1 answer

sql server - How to push the data from database to application?

I want to push the data from database to application instead of application pull the data. I have installed ... suggestion please post it. See Question&Answers more detail:os...

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

0 votes

890 views

1 answer

sql - Error: "OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC Driver Manager] Data source name not found ..."

If I execute the following command: select * from OpenRowset ( 'MSDASQL', 'Driver={Microsoft Text Driver (*.txt;* ... " (see my comments below). See Question&Answers more detail:os...

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

0 votes

864 views

1 answer

sql - How to Merge Multiple Database files in SQLite?

I have multiple database files which exist in multiple locations with exactly similar structure. I understand the attach ... the 'master table'? See Question&Answers more detail:os...

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

0 votes

358 views

1 answer

sql server - How to load large table into tableau for data visualization?

I am able to connect tableau with my database but the table size is really large here. Everytime I try ... approach this issue any suggestion ? See Question&Answers more detail:os...

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

0 votes

447 views

1 answer

sql - Recursive Query for Bill Of Materials

I've just started teaching myself SQL recently and have been able to piece together almost everything I need from ... to the result set. Thanks See Question&Answers more detail:os...

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

0 votes

623 views

1 answer

sql - Can I get a unique TIMESTAMP for every record in MySQL

Is there a possibility of getting a unique timestamp value for for each record in MySQL??.. I created a sample table ... name) values(1,"test"); See Question&Answers more detail:os...

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

0 votes

606 views

1 answer

sql - There is already an object named '#tmptable' in the database

I′m trying to execute stored procedure but I get an issue of an existing temporal table, but I just create one ... How can I solve it? Regards See Question&Answers more detail:os...

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

0 votes

425 views

1 answer

sql - Can you have a Foreign Key onto a View of a Linked Server table in SQLServer 2k5?

I have a SQLServer with a linked server onto another database somewhere else. I have created a view on that ... can achieve the same effect? See Question&Answers more detail:os...

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

0 votes

309 views

1 answer

sql server - Entity Framework cached query plan performance degrades with different parameters

I have the following problem. Background I'm trying to implement an autocomplete selector with MVC3, EF4 and jquery ... great. Thanx in advance! See Question&Answers more detail:os...

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

0 votes

429 views

1 answer

sql - Array of arrays in PostgreSQL

I'm using the %% operator on PostgreSQL's hstore type which converts a hstore (key-value type effectively) into ... key-values etc. Many thanks. See Question&Answers more detail:os...

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

0 votes

837 views

1 answer

sql - How to get age in years,months and days using Oracle

I'm trying to print for each person its age using this format : E.g : 19 years , 8 months , 13 days. I've ... can't figure it out , any ideas ? See Question&Answers more detail:os...

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

0 votes

501 views

1 answer

sql server - Can you subtotal rows and/or columns in a pivot table?

I have a set of queries that outputs a pivot table. Is it possible to obtain row and/or column subtotals ... Thanks for your assistance ! -Don See Question&Answers more detail:os...

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

0 votes

478 views

1 answer

sql - Limiting the number of records in a Sqlite DB

What I'm trying to implement here is a condition wherein a sqlite database holds only the most recent 1000 ... records older than two years See Question&Answers more detail:os...

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

0 votes

438 views

1 answer

sql - Get notified when database change Android

I have a SQL Server database and when there is insert in a table I want to notify the Android app. For example, ... so. Is there any other way? See Question&Answers more detail:os...

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

0 votes

445 views

1 answer

sql server - SQL: retrieve only the records whose value has changed

Sorry for the nondescript title. I'll edit as we go along. I have a table RateTable: | Code | Date | ... change occurs? I'm using SQLServer See Question&Answers more detail:os...

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

0 votes

756 views

1 answer

sql - Reason for - ORDER BY items must appear in the select list if SELECT DISTINCT is specified

I know that the query below causes the error - ORDER BY items must appear in the select list if SELECT ... it displays an error message. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags