Recent questions tagged SQL

0 votes

488 views

1 answer

sql server - SSIS reading LF as terminator when its set as CRLF

using SSIS 2012. My flat file connection manager I have a delimited file where the row delimiter is set to CRLF, ... causing it fail. Any ideas? See Question&Answers more detail:os...

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

0 votes

456 views

1 answer

sql - Coldfusion - variable field name when looping through database query results

I have a set of column names in a table - e.g. foo1, foo2, foo3, foo4. I want to refer to these column ... results. How else can I do this? See Question&Answers more detail:os...

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

0 votes

802 views

1 answer

sql - Achieving ROW_NUMBER / PARTITION BY in MS Access

How can you make use of "Row number over partition by" in MS access? I googled it, but couldn't find any ... taking more time as f 30 seconds See Question&Answers more detail:os...

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

0 votes

270 views

1 answer

sql - Optimize groupwise maximum query

select * from records where id in ( select max(id) from records group by option_id ) This query works fine even on ... , 1 warning (0.02 sec) See Question&Answers more detail:os...

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

0 votes

325 views

1 answer

sql server - How to set bool value in SQL

I have a column which is bool. How can I set true, false values for that? Here is my query : Update [mydb]. ... or 1 AS BIT or something else? See Question&Answers more detail:os...

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

0 votes

245 views

1 answer

sql - How to select records with maximum values in two columns?

It was hard to come up with an understandable title for this question. I'll try to explain with an example. ... How should such query look like? See Question&Answers more detail:os...

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

0 votes

276 views

1 answer

sql - Store multiple bit values in a single table column

I need to store some sort of day-of-week scheduling in database, where I can schedule a record (say it ... and easy to implement solutions. See Question&Answers more detail:os...

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

0 votes

387 views

1 answer

sql server - Multiple Column Pivot in T-SQL

I am working with a table where there are multiple rows that I need pivoted into columns. So the pivot is the ... found in field3, field4....? See Question&Answers more detail:os...

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

0 votes

416 views

1 answer

sql - Is it possible to have a default parameter for a mysql stored procedure?

I have googled this and keep coming up with "No it is not possible" but these posts were dated 2005-2007 so I ... more I could do with MSSQL. See Question&Answers more detail:os...

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

0 votes

593 views

1 answer

sql - Alphanumeric sorting with PostgreSQL

In the database, I have various alpha-numeric strings in the following format: 10_asdaasda 100_inkskabsjd ... appreciate any help! See Question&Answers more detail:os...

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

0 votes

271 views

1 answer

sql - Aggregate a single column in query with many columns

Is there a proper way to aggregate a single column when I have many other columns in the query? I've tried this answer ... 4.1.2-54), 64-bit See Question&Answers more detail:os...

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

0 votes

450 views

1 answer

sql - How to fill date gaps in MySQL?

How i can fill date gaps in MySQL? Here is my query: SELECT DATE(posted_at) AS date, COUNT(*) AS total, SUM( ... by zeros. How i can do this? See Question&Answers more detail:os...

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

0 votes

369 views

1 answer

sql - How does this CASE expression reach the ELSE clause?

I need to load some test data into the Channel field on my Account table. The Channel can be one of 10 ... ensure that ELSE is never reached? See Question&Answers more detail:os...

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

0 votes

535 views

1 answer

sql - SQLite auto-increment non-primary key field

Is it possible to have a non-primary key to be auto-incremented with every insertion? For example, I want to ... are not supported in SQLite. See Question&Answers more detail:os...

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

0 votes

367 views

1 answer

sql - Entity Framework - attribute IN Clause usage

I need to filter some Entities by various fields using "normal" WHERE and IN clauses in a query over my database, ... to do this query in EF? See Question&Answers more detail:os...

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

0 votes

314 views

1 answer

sql server - Return all possible combinations of values on columns in SQL

How do I return a list of all combinations of values in 2 columns so they are new rows in T-SQL? e.g. Col1, Col2 ---- - ... 1 4 1 5 2 4 2 5 4 5 See Question&Answers more detail:os...

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

0 votes

324 views

1 answer

sql server - Assign result of dynamic sql to variable

I'm doing dynamic SQL to convert all columns in a table a string so After after all I do EXEC(@template); ... ; SET @result = EXEC(@template); See Question&Answers more detail:os...

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

0 votes

491 views

1 answer

sql - How can I include null values in a MIN or MAX?

I have a table where I am storing timespan data. the table has a schema similar to: ID INT NOT NULL IDENTITY(1,1 ... 4 2004-05-06 2009-12-01 See Question&Answers more detail:os...

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

0 votes

363 views

1 answer

sql server - T-SQL How to create tables dynamically in stored procedures?

Code like this, but it's wrong: CREATE PROC sp_createATable @name VARCHAR(10), @properties VARCHAR(500) AS CREATE ... ? It really troubles me. See Question&Answers more detail:os...

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

0 votes

324 views

1 answer

sql server - TSQL: Create a view that accesses multiple databases

I have a special case, for example in table ta in database A, it stores all the products I buy table ta( ... products that I haven`t bought? See Question&Answers more detail:os...

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

0 votes

502 views

1 answer

sql - Execute Immediate within a stored procedure keeps giving insufficient priviliges error

Here is the definition of the stored procedure: CREATE OR REPLACE PROCEDURE usp_dropTable(schema VARCHAR, tblToDrop ... to the solution. See Question&Answers more detail:os...

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

0 votes

409 views

1 answer

sql - Mysql insert random datetime in a given datetime range

With SQL , Can I insert random datetime values in a column giving a range? For example, given a range of 2010-04 ... ` VALUES (RND (DATETIME())) See Question&Answers more detail:os...

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

0 votes

267 views

1 answer

sql - Can select * usage ever be justified?

I've always preached to my developers that SELECT * is evil and should be avoided like the plague. Are there any ... the end of the field list. See Question&Answers more detail:os...

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

0 votes

299 views

1 answer

sql server select first row from a group

I have table like this: a b 1 23 1 2 1 7 2 9 2 11 I want to select the first row(order does not ... 2008 how to write the query for this? See Question&Answers more detail:os...

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

0 votes

248 views

1 answer

sql server - How to load an XML file into a database using an SSIS package?

I am using SSIS in Visual Studio 2008. I have many XML files that I need to process and place into an ... an XML source for each table? See Question&Answers more detail:os...

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

0 votes

290 views

1 answer

sql - Explain JOIN vs. LEFT JOIN and WHERE condition performance suggestion in more detail

In this candidate answer it is asserted that JOIN is better than LEFT JOIN under some circumstances involving some ... s) for further reading. See Question&Answers more detail:os...

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

0 votes

234 views

1 answer

sql - How to insert a file in MySQL database?

I want to insert a file in MYSQL database residing on a remote webserver using a webservice. My question is: What ... in case of a file? See Question&Answers more detail:os...

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

0 votes

370 views

1 answer

sql - How to replace (null) values with 0 output in PIVOT

I tried to convert the (null) values with 0 (zeros) output in PIVOT function but have no sucess. Below is ... its syntax error? Thanks a lot! See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags