Recent questions tagged SQL

0 votes

827 views

1 answer

sql - How to use MySQL like with order by exact match first

I'm using MySQL 5.5 so that's why I can't use FULLTEXT search so please don't suggest it. What I ... first as exact match then Amit & Amitesh See Question&Answers more detail:os...

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

0 votes

688 views

1 answer

sql server - How do I fix 'Invalid character value for cast specification' on a date column in flat file?

I have a CSV file with a {LF} delimiting each row and a date column with the date format as "12/20/2010" ... it stays the same in the pipeline See Question&Answers more detail:os...

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

0 votes

730 views

1 answer

sql server - SSIS mysterious error

I got only these 2 errors when converting flat files to database tables. The dataflow seems to work for ... more information about the failure. See Question&Answers more detail:os...

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

0 votes

475 views

1 answer

sql server - Does or does not SQL Azure support CLR assemblies?

We've got a couple of on-premises dbs and we're seeing if we can migrate them to SQL Azure. Some of ... supported in azure. Thanks guys! Luis See Question&Answers more detail:os...

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

0 votes

627 views

1 answer

sql server - T-SQL conditional UPDATE (v2)

I have a table: Message (MessageID int, Subject nvarchar(100), Body nvarchar(max)) After a message is being ... can be updated, not two) See Question&Answers more detail:os...

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

0 votes

562 views

1 answer

sql server - Characters that must be escaped in T-SQL

I was looking for a list of special characters that must be escaped in ms sql server but could not find ... cause trouble Appreciate your help See Question&Answers more detail:os...

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

0 votes

852 views

1 answer

sql server - Cursor verus while loop - what are the advantages/disadvantages of cursors?

Is it a good idea to use while loop instead of a cursor? What are the advantages/disadvantages of cursors? See Question&Answers more detail:os...

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

0 votes

630 views

1 answer

sql - MySQL using Sum and Case

I'm trying to create a GridView with ASP.NET connecting to a MySQL database. The data appears like below. ... Case the best use here? See Question&Answers more detail:os...

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

0 votes

683 views

1 answer

sql server - SQL Query Where Date = Today Minus 7 Days

I have a SQL table of hits to my website called ExternalHits. I track the URL as URLx and the date the page ... BY URLx ORDER BY Count DESC; See Question&Answers more detail:os...

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

0 votes

851 views

1 answer

sql - Error - "UNION operator must have an equal number of expressions" when using CTE for recursive selection

At this moment I have a table tblLocation with columns ID, Location, PartOfID. The table is recursively connected ... output it would be great. See Question&Answers more detail:os...

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

0 votes

538 views

1 answer

sql - SELECT *, COUNT(*) in SQLite

If i perform a standard query in SQLite: SELECT * FROM my_table I get all records in my table as expected. If ... and unlogical to me :(. See Question&Answers more detail:os...

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

0 votes

722 views

1 answer

sql - Error (ORA-00923: FROM keyword not found where expected)

select country_olympic_name, SUM(part_gold) as 'Number of Gold Medals' From games.country, games.participation where ... know why, please help See Question&Answers more detail:os...

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

0 votes

816 views

1 answer

sql - There are no Primary or Candidate Keys in the referenced table

Error: There are no Primary or Candidate Keys in the referenced table 'dbo.Customers' that match the referencing ... reference a primary key. See Question&Answers more detail:os...

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

0 votes

719 views

1 answer

sql - product with multiple category type database schema

I want to store information about song files which they are categorized by: 1. genre for example: pop, ... sub categories? thanks in advance See Question&Answers more detail:os...

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

0 votes

920 views

1 answer

sql - Android Room FOREIGN KEY constraint failed (code 787)

I'm tying to create a database in Android Room with two foreign keys. Every time I try to insert a track into ... = "name") private String name; See Question&Answers more detail:os...

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

0 votes

549 views

1 answer

sql - find all parent records where all child records have a given value (but not just some child records)

An event has many participants. A participant has a field of "status". class Event < ActiveRecord::Base ... to ActiveRecord or SQL solutions. See Question&Answers more detail:os...

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

0 votes

683 views

1 answer

sql server - ValidateExternalMetadata property, what exactly does this do?

I have a package which reads data from a table and based on a column value stores the records in two other ... no indexes on the table before. See Question&Answers more detail:os...

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

0 votes

623 views

1 answer

sql server - SQL Find missing date ranges

I have a table that holds all the days/months of the year E.G. Day Month 1 9 2 9 3 9 4 9 5 9 6 9 7 ... 09/2013 - 19/09/2013 Thanks for any help! See Question&Answers more detail:os...

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

0 votes

833 views

1 answer

sql server 2008 - Insert query in SQL Function

Can i write a insert query inside Function in SQL server 2008. If i tried, im a getting an error of ... values (@i_db_name) return 0 end See Question&Answers more detail:os...

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

0 votes

618 views

1 answer

sql - Create a unique index on a non-unique column

Not sure if this is possible in PostgreSQL 9.3+, but I'd like to create a unique index on a non-unique ... every time we insert into data. See Question&Answers more detail:os...

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

0 votes

617 views

1 answer

sql - What is wrong with this mysql query?

This works: CREATE TABLE shoutbox_shout ( shout_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, user_id INT UNSIGNED ... still get error. See Question&Answers more detail:os...

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

0 votes

656 views

1 answer

sql - Hive select data into an array of structs

I am trying to figure out a way in Hive to select data from a flat source and output into an array of named ... I might go about this in Hive? See Question&Answers more detail:os...

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

0 votes

809 views

1 answer

sql server - Deserialize XML object in T-SQL

I've got an XML object. And I want to deserialize it into a table using T-SQL. <Params> <type = 1> < ... data into a table like this: Thanks! See Question&Answers more detail:os...

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

0 votes

590 views

1 answer

sql - Map database type to concrete Java class

Background Map a column data type to its corresponding Java class. Problem A query returns meta information from a ... for a given data type? See Question&Answers more detail:os...

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

0 votes

515 views

1 answer

sql server - How to retrieve all errors and messages from a query using ADO

When a SQL batch returns more than one message from e.g. print statements, then I can only retrieve the ... to get the remaining messages? See Question&Answers more detail:os...

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

0 votes

596 views

1 answer

sql - Mysql max value from 3 different columns

Is there any way to find maximum value of 3 different columns? I'm trying to find records with any of 3 ... (column1, column2, column3) > 69 See Question&Answers more detail:os...

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

0 votes

666 views

1 answer

sql server - SQL IsNumeric not working

The reserve column is a varchar, to perform sums on it I want to cast it to a deciaml. But the SQL below ... = 1 and MyReserves is not null See Question&Answers more detail:os...

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

0 votes

814 views

1 answer

sql - MySQL : sum of every day

I have a table as follow: datetime (datetime) count (int) 2012-12-27 09:22:15 5 2012-12-27 18:20:15 4 2012-12 ... 12 2012-12-26 15 2012-12-25 3 See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags