Recent questions tagged SQl

0 votes

261 views

1 answer

sql - What is the resource impact from normalizing a database?

When taking a database from a relatively un-normalized form and normalizing it, what, if any, changes in ... normalization as much as possible. See Question&Answers more detail:os...

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

0 votes

291 views

1 answer

sql server 2008 - Migrating ASP.NET Membership Database to SQL Azure

I am trying to migrate a database from SQL Server 2008 to SQL Azure. The database that I am attempting to ... overcome this issue? Thank you! See Question&Answers more detail:os...

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

0 votes

559 views

1 answer

sql - SELECT DISTINCT is slower than expected on my table in PostgreSQL

Here's my table schema: CREATE TABLE tickers ( product_id TEXT NOT NULL, trade_id INT NOT NULL, sequence BIGINT ... min/max for certain columns See Question&Answers more detail:os...

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

0 votes

389 views

1 answer

sql - How to display a default value when no match found in a query?

I want to display a default message when there is no data obtained from a query. For example Let us take a ... this. I am using Oracle 10g. See Question&Answers more detail:os...

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

0 votes

481 views

1 answer

sql - BigQuery GROUP_CONCAT and ORDER BY

I am currently using BigQuery and GROUP_CONCAT which works perfectly fine. However, when I try to add a ORDER BY ... on how to approach this? See Question&Answers more detail:os...

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

0 votes

412 views

1 answer

sql - Python: DISTINCT on GQuery result set (GQL, GAE)

Imagine you got an entity in the Google App Engine datastore, storing links for anonymous users. You would like ... the DISTINCT result set? See Question&Answers more detail:os...

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

0 votes

235 views

1 answer

sql - Is using COUNT(*) or SELECT * a good idea?

I've heard several times that you shouldn't perform COUNT(*) or SELECT * for performance reasons, but ... further information about the topic? See Question&Answers more detail:os...

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

0 votes

422 views

1 answer

sql - Datatype/structure to store timezone offset in MySQL

Which would be the proper datatype/structure to store timezone offsets in MySQL? I just want to store the numeric value ... city 2:00 Bonn, GER See Question&Answers more detail:os...

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

0 votes

311 views

1 answer

sql server - TSQL Writing into a Temporary Table from Dynamic SQL

Consider the following code: SET @SQL1 = 'SELECT * INTO #temp WHERE ...' exec(@SQL1) SELECT * from #temp ( ... . What do you all recommend? See Question&Answers more detail:os...

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

0 votes

345 views

1 answer

sql server - Sql LEFT OUTER JOIN with WHERE clause

I have two tables: Request: RequestID | Msg ---------------- 5 | abc 6 | def 7 | ghi 8 | jkl ... StatusID = 1) of course it does not work. See Question&Answers more detail:os...

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

0 votes

274 views

1 answer

sql - How does 'in' clause works in oracle

select 'true' from dual where 1 not in (null,1); when we execute this which will result nothing what ... as above statement Please clarify? See Question&Answers more detail:os...

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

0 votes

426 views

1 answer

sql - Does the number of columns returned affect the speed of a query?

If I have two queries SELECT Id, Forename, Surname FROM Person WHERE PersonName Like( %frank%') And SELECT * FROM ... sensible, or is it naive? See Question&Answers more detail:os...

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

0 votes

349 views

1 answer

sql server - Is this date comparison condition SARG-able in SQL?

Is this condition sargable? AND DATEDIFF(month,p.PlayerStatusLastTransitionDate,@now) BETWEEN 1 AND 7) My rule of thumb ... be improved more :) See Question&Answers more detail:os...

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

0 votes

390 views

1 answer

sql - how to best organize the Inner Joins in (select) statement

let's say i have three tables, each one relates to another, when i need to get a column from each table, does ... Inner Join table3 on ..... See Question&Answers more detail:os...

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

0 votes

364 views

1 answer

sql - Calculate the last day of the prior quarter

What's the most efficient way to calculate the last day of the prior quarter? Example: given the date 11/19/ ... 30/2008. Platform is SQL Server See Question&Answers more detail:os...

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

0 votes

299 views

1 answer

sql - Insertion of data after creating index on empty table or creating unique index after inserting data on oracle?

Which option is better and faster? Insertion of data after creating index on empty table or creating unique ... could have least downtime. See Question&Answers more detail:os...

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

0 votes

341 views

1 answer

sql server - SQL Multiple LIKE Statements

I'm currently working on a report that shows me all post codes covered by our sales team. Each team covers ... fishing for ideas really. Cheers See Question&Answers more detail:os...

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

0 votes

342 views

1 answer

sql - How to get the end of a day?

I'm using PostgreSQL 8.4. I have a column of the table my_tbl which contains dates (timestamp without timezone). For ... to the end of the day. See Question&Answers more detail:os...

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

0 votes

321 views

1 answer

sql - How to remove part of the string in oracle

Input data: abcdef_fhj_viji.dvc Expected output: fhj_viji.dvc The part to be trimmed is not constant. See Question&Answers more detail:os...

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

0 votes

804 views

1 answer

sql - Cascade on Delete or use Triggers?

Im going through a project I have taken over, and on the database side I have noticed that the previous ... fine? Im using MSSQL 2008. See Question&Answers more detail:os...

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

0 votes

438 views

1 answer

sql - Get Excel sheet into temp table using a script

Im trying to get this excel sheet into a table, so I can apply select statements to it etc, to update tables ... for linked server "(null)". See Question&Answers more detail:os...

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

0 votes

301 views

1 answer

sql - SPARK : failure: ``union'' expected but `(' found

I have a dataframe called df with column named employee_id. I am doing: df.registerTempTable("d_f") val ... BY employee_id) row_number FROM d_f See Question&Answers more detail:os...

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

0 votes

442 views

1 answer

sql - How to emulate REPEAT() in SQLite

Most relational databases have some sort of REPEAT() string function, for instance: SELECT REPEAT('abc', 3) ... functions available in SQLite? See Question&Answers more detail:os...

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

0 votes

477 views

1 answer

sql - Using a comma-separated parameter in an IN clause

I have 'param1, param2, parma3' coming from SSRS to a stored procedure as a varchar parameter: I ... creating functions and parameter tables? See Question&Answers more detail:os...

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

0 votes

448 views

1 answer

sql server - SSRS: repeat tablix left-most row group value on each row

I have a tablix in an SSRS 2008 report. It has two-level row groupings, and I'd like the value for the left ... thing to want? Thank you, Bill See Question&Answers more detail:os...

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

0 votes

283 views

1 answer

sql - How use inserteddeleted table in stored procedure?

I creating triggers for several tables. The triggers have same logic. I will want to use a common stored ... (@FiledId) end commit tran See Question&Answers more detail:os...

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

0 votes

329 views

1 answer

sql server - HTTP Status 500 - Java Runtime Environment (JRE) version 1.7 is not supported by this driver

I am trying to access MS SQL server 2005 from a servlet file. I am using JDBC 4.0 driver. I have already ... ); res.setContentType("text/html"); See Question&Answers more detail:os...

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

0 votes

401 views

1 answer

sql - How to check if a value is a number in SQLite

I have a column that contains numbers and other string values (like "?", "???", etc.) Is it ... * from mytable where isnumber(mycolumn) See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags