Recent questions tagged SQL

0 votes

387 views

1 answer

sql - MySQL full text search for words with three or less letters

I'm trying to get my full text search (in boolean mode) to retrieve words with three letters or less. Currently, if ... to do this on the fly. See Question&Answers more detail:os...

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

0 votes

324 views

1 answer

sql - MySQL: LIMIT by a percentage of the amount of records?

Let's say I have a list of values, like this: id value ---------- A 53 B 23 C 12 D 72 E 21 F ... of records before I do the query. Any idea's? See Question&Answers more detail:os...

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

0 votes

255 views

1 answer

sql - Oracle insert if row does not exist

insert ignore into table1 select 'value1',value2 from table2 where table2.type = 'ok' When I run this I get the error "missing INTO keyword". See Question&Answers more detail:os...

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

0 votes

270 views

1 answer

sql server 2008 - Entity Framework Database.SetInitializer simply not working

I am having this kind of "mysterious" issue here. I am currently using Entity Framework 4.1 Code First approach ... + SQL Server Express 2008 R2 See Question&Answers more detail:os...

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

0 votes

231 views

1 answer

sql server - What is the sql connection string I need to use to access localhostSQLEXPRESS with Windows Authentication or SQL Authentication?

've installed SQL Express on my PC hoping to do some practice creating tables and then modifying them. I coded a ... for user 'x309-PCx309'. See Question&Answers more detail:os...

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

0 votes

238 views

1 answer

sql - Why are logical reads for windowed aggregate functions so high?

I've found that in execution plans using common subexpression spools that the reported logical reads get quite ... NULL DROP TABLE #WorkTable See Question&Answers more detail:os...

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

0 votes

574 views

1 answer

sql - sqlite equivalent of row_number() over ( partition by ...?

I'd like to know if it's possible to do the following using a single sqlite statement: My table looks ... those records that'd be fine. See Question&Answers more detail:os...

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

0 votes

411 views

1 answer

sql - Bulk insert using stored procedure

I have a query which is working fine: BULK INSERT ZIPCodes FROM 'e:5-digit Commercial.csv' WITH ( FIRSTROW ... work in stored procedure. Thanks See Question&Answers more detail:os...

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

0 votes

220 views

1 answer

sql - How to store array or multiple values in one column

Running Postgres 7.4 (Yeah we are in the midst of upgrading) I need to store from 1 to 100 selected ... so no mappings or referencing tables. See Question&Answers more detail:os...

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

0 votes

315 views

1 answer

sql server - Does Sql JOIN order affect performance?

I was just tidying up some sql when I came across this query: SELECT jm.IMEI , jm.MaxSpeedKM , jm.MaxAccel , ... the other 2 tables to that one See Question&Answers more detail:os...

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

0 votes

314 views

1 answer

sql - Continuing a transaction after primary key violation error

I am doing a bulk insert of records into a database from a log file. Occasionally (~1 row out of ... (importing via Python/psycopg2). See Question&Answers more detail:os...

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

0 votes

347 views

1 answer

sql server - Calling stored procedure using VBA

I am working in Access 2010 user front-end with a Microsoft SQL Server 2008 back-end. The tables in Access are ... why I am getting this error? See Question&Answers more detail:os...

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

0 votes

463 views

1 answer

sql - mysql select distinct rows into a comma delimited list column

I currently have some sql that brings back tags. they should have distinct ids, but they don't.... so my current ... am using mySQL 5 for this. See Question&Answers more detail:os...

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

0 votes

221 views

1 answer

sql server - Grant Select on a view not base table when base table is in a different database

I have a view which is selecting rows from a table in a different database. I'd like to grant select access to ... not do it the latter way. See Question&Answers more detail:os...

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

0 votes

235 views

1 answer

sql - Building a comma separated list?

I'm tryin to use SQL to build a comma separated list of cat_id's the code is: declare @output varchar(max) set ... be there. What have i missed? See Question&Answers more detail:os...

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

0 votes

227 views

1 answer

sql - CHECK CONSTRAINT on multiple columns

I use SQL Server 2008 I use a CHECK CONSTRAINT on multiple columns in the same table to try to ... EffectiveEndDate > EffectiveStartDate), ); See Question&Answers more detail:os...

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

0 votes

305 views

1 answer

sql server - sql use statement with variable

I'm trying to switch the current database with a SQL statement. I have tried the following, but all attempts ... Database2 SELECT * FROM Table2 See Question&Answers more detail:os...

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

0 votes

540 views

1 answer

sql - Incorrect syntax near ''

I'm trying to run the following fairly simple query in SQL Server Management Studio: SELECT TOP 1000 * FROM master. ... what it doesn't like. See Question&Answers more detail:os...

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

0 votes

214 views

1 answer

sql - Renaming foreign-key columns in MySQL

We're trying to rename a column in MySQL (5.1.31, InnoDB) that is a foreign key to another table. At ... ? Any help would be much appreciated! See Question&Answers more detail:os...

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

0 votes

276 views

1 answer

sql - Selecting first row per group

I have a table with three columns: A,B,C. The values are: +---+-----+----+ | A | B | C | +---+-----+----+ | 1 ... 5 | -5 | 6 | +---+-----+----+ See Question&Answers more detail:os...

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

0 votes

278 views

1 answer

sql - Selecting all corresponding fields using MAX and GROUP BY

I have this table : And I would like to make a request that would return for each deal_id the row with the highest ... 1, 2009-08-17 14:31:25 See Question&Answers more detail:os...

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

0 votes

380 views

1 answer

sql - Getting the Last Insert ID with SQLite.NET in C#

I have a simple problem with a not so simple solution... I am currently inserting some data into a database like ... that is also a problem... See Question&Answers more detail:os...

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

0 votes

241 views

1 answer

sql server - Curly braces in T-SQL

I've come across the following t-sql: SELECT {d'9999-12-31'} Which returns 9999-12-31 00:00:00. ... further information on this syntax? Thanks. See Question&Answers more detail:os...

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

0 votes

404 views

1 answer

sql - Can I set ignore_dup_key on for a primary key?

I have a two-column primary key on a table. I have attempted to alter it to set the ignore_dup_key to on ... should I set IGNORE_DUP_KEY to on? See Question&Answers more detail:os...

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

0 votes

325 views

1 answer

sql server 2005 - Calculating timespan with t-sql

Given two date/times: @start_date = '2009-04-15 10:24:00.000' @end_date = '2009-04-16 19:43:01.000' ... dates in the following format 1d 9h 19m See Question&Answers more detail:os...

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

0 votes

373 views

1 answer

sql - Why does VARCHAR need length specification?

Why do we always need to specify VARCHAR(length) instead of just VARCHAR? It is dynamic anyway. UPD: I'm puzzled ... mandatory (e.g. in MySQL). See Question&Answers more detail:os...

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

0 votes

390 views

1 answer

sql - Nth max salary in Oracle

To find out the Nth max sal in oracle i'm using below query SELECT DISTINCE sal FROM emp a WHERE ( SELECT ... time for a query to execute. See Question&Answers more detail:os...

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

0 votes

192 views

1 answer

sql server - Tool for Scripting Table Data

Are there any free tools for scripting MSSQL table data? I'll gladly write one, but am hoping it's been done, and the app matured a bit before/ See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags