Recent questions tagged sql

0 votes

268 views

1 answer

sql server - LINQ to SQL Take w/o Skip Causes Multiple SQL Statements

I have a LINQ to SQL query: from at in Context.Transaction select new { at.Amount, at.PostingDate, Details ... See my answer below for details. See Question&Answers more detail:os...

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

0 votes

306 views

1 answer

sql - Grouping and counting rows by value until it changes

I have a table where messages are stored as they happen. Usually there is a message 'A' and sometimes the A's are separated ... A 2 B 1 A 3 B 1 See Question&Answers more detail:os...

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

0 votes

424 views

1 answer

sql server - split alpha and numeric using sql

I have a table and it has a 3 columns. The first column is the data that contains value(numeric) and unit( ... im using sql server 2005. Thanks! See Question&Answers more detail:os...

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

0 votes

856 views

1 answer

sql server 2008 - Using Dapper with SQL Spatial Types as a parameter

I've got a system which basically has to do a query like this: SELECT * FROM MyTable WHERE @parameter. ... SqlGeometry object as a parameter. See Question&Answers more detail:os...

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

0 votes

374 views

1 answer

sql - How to find the average time difference between rows in a table?

I have a mysql database that stores some timestamps. Let's assume that all there is in the table is the ID and the ... a way to do it in SQL? See Question&Answers more detail:os...

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

0 votes

243 views

1 answer

sql - How to find the record in a table that contains the maximum value?

Although this question looks simple, it is kind of tricky. I have a table with the following columns: table A: ... " repeats). Can someone help? See Question&Answers more detail:os...

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

0 votes

347 views

1 answer

sql - jsonb query with nested objects in an array

I'm using PostgreSQL 9.4 with a table teams containing a jsonb column named json. I am looking for a query where I ... a team, not all of them. See Question&Answers more detail:os...

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

0 votes

372 views

1 answer

sql - DELETE Command is too slow in a Table with Clustered Index

I have a rather big table named FTPLog with around 3 milion record I wanted to add a delete mechanism to ... I improve performance of deleting? See Question&Answers more detail:os...

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

0 votes

220 views

1 answer

sql - How to Update same table on deletion in MYSQL?

In my database I have a table Employee that has recursive association (an employee can be boss of other employee): ... IF; END// DELIMITER ; See Question&Answers more detail:os...

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

0 votes

464 views

1 answer

sql update - MySQL CASE...WHERE...THEN statements

I have a MySQL UPDATE statement that uses a CASE clause UPDATE partsList SET quantity = CASE WHEN partFK = 1 ... any insights you can provide. See Question&Answers more detail:os...

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

0 votes

357 views

1 answer

sql - How can I tell if I have uncommitted work in an Oracle transaction?

Is there a way to tell if I have uncommitted work (ie DML) in a transaction? Maybe a data-dictionary ... would be welcome. Thank you See Question&Answers more detail:os...

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

0 votes

300 views

1 answer

sql - Get column names

I need to get all of the column names of a table using VBA or Access SQL and iterate through them for ... have searched Google to no avail. See Question&Answers more detail:os...

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

0 votes

280 views

1 answer

sql - Prevent insert if condition is met

I have a table Content like this: id | text | date | idUser → User | contentType And another table Answer: idAnswer ... and how can I solve it? See Question&Answers more detail:os...

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

0 votes

388 views

1 answer

sql server - How to check the SSIS package job results after it has completed its execution?

I have an SSIS package which imports the data into the SQL Server 2008 database. I have set up the schedule ... fulfill my requirements or not. See Question&Answers more detail:os...

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

0 votes

263 views

1 answer

sql - Flattening intersecting timespans

I have lots of data with start and stop times for a given ID and I need to flatten all intersecting and adjacent ... 05:56:27 | 03:45:54 See Question&Answers more detail:os...

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

0 votes

360 views

1 answer

sql - Why is the foreign key part of the primary key in an identifying relationship?

I'm trying to understand a concept rather than fixing a piece of code that won't work. I'll take a ... benefit of these composite primary keys? See Question&Answers more detail:os...

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

0 votes

282 views

1 answer

sql server - Why is my t-sql left join not working?

Can you run this and tell me why the result set only has two rows. It should have three and look like ... from #appSteps are not coming back See Question&Answers more detail:os...

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

0 votes

441 views

1 answer

sql - can I use a variable to specify OUTFILE in mysql

Is there a way to do something like the following ? which doesn't work but shows what I want to do SET ... BY '"' FROM database.tableName2; See Question&Answers more detail:os...

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

0 votes

257 views

1 answer

sql server - SQL: search for a string in every varchar column in a database

I have a database where a misspelled string appears in various places in different tables. Is there a SQL query ... SQL Server if that helps. See Question&Answers more detail:os...

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

0 votes

449 views

1 answer

sql server 2005 - Difference between Implicit and Explicit Transaction

What is the difference between Implicit and Explicit transaction in Sql Server 2008? What happens in TransactionScope ... How does it work? See Question&Answers more detail:os...

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

0 votes

324 views

1 answer

sql server - When the performance of Distinct and Group By are different?

I know in simple queries the performance and execution plans of the Distinct and Group By are almost the same ... are different? Many thanks See Question&Answers more detail:os...

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

0 votes

675 views

1 answer

sql - How to store a string var greater than varchar(max)?

I'm trying to do this: DECLARE @myVar VARCHAR(MAX) Loop with cursor select @myVar = @myVar + bla bla bla ... others through the web. Regards. See Question&Answers more detail:os...

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

0 votes

435 views

1 answer

sql - Is it a better practice to explicitly call transaction rollback or let an exception trigger an implicit rollback?

In the below code if any exception is thrown while executing the the SQL statements we should expect an implicit rollback ... (); throw; } } See Question&Answers more detail:os...

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

0 votes

352 views

1 answer

sql - How to schedule a stored procedure?

How do I schedule a stored procedure in Sql Server 2005 that it runs once at the start of every month (and on database startup)? See Question&Answers more detail:os...

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

0 votes

536 views

1 answer

sql - Select most recent row with GROUP BY in MySQL

I'm trying to select each user with their most recent payment. The query I have now selects the users first ... . All help appreciated. Thanks. See Question&Answers more detail:os...

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

0 votes

389 views

1 answer

sql - Using Hibernate's Criteria and Projections to Select Multiple Distinct Columns

Using Hibernate's Criteria, I want to execute the equivalent of: select distinct uspscity, state from citycomplete ... this? Thanks, Brandon See Question&Answers more detail:os...

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

0 votes

332 views

1 answer

sql - mysql get table column names in alphabetical order

Is it possible to query a MySQL database to get the column names of a table in alphabetical order? I know that ... , it gave a syntax error. See Question&Answers more detail:os...

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

0 votes

356 views

1 answer

sql - MySQL - Select only numeric values from varchar column

Consider the following table : create table mixedvalues (value varchar(50)); insert into mixedvalues values ('100' ... 200 300 400 500 SQLFiddle See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags