Recent questions tagged SQL

0 votes

520 views

1 answer

sql - SQLite format number with 2 decimal places always

I have some tables in a SQLite database that contains FLOAT column type, now i want to retrieve the value with a ... be done in SQLite ? Thanks. See Question&Answers more detail:os...

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

0 votes

266 views

1 answer

sql - How to get stored procedure parameters details?

Where can I find information about stored procedure parameters? In my situation I need to know only the input ... details in that way. See Question&Answers more detail:os...

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

0 votes

302 views

1 answer

sql - MySQL select records for duplicates using multiple columns

I would like the select records from a table, or insert them into a new blank table where multiple of the ... only one column as a comparison. See Question&Answers more detail:os...

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

0 votes

296 views

1 answer

sql - Can't see MySQL BIT field value when using SELECT

my_table contains the enabled field which is defined as: enabled BIT NOT NULL DEFAULT 0. This table has multiple ... x86_64) using readline 6.1 See Question&Answers more detail:os...

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

0 votes

305 views

1 answer

sql - Increment field of mysql database using codeigniter's active record syntax

I have the following php-codeigniter script which attempts to increment a field of a record using active-record ... 's active record syntax? See Question&Answers more detail:os...

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

0 votes

272 views

1 answer

sql - Datetime in where clause

How can I select 12/20/2008 in where clause of sql? The server is SQL server 2005. select * from tblErrorLog where errorDate = '12/20/2008' See Question&Answers more detail:os...

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

0 votes

516 views

1 answer

sql - What is the difference bewteen ifnull and coalesce in mysql?

select ifnull(null,'replaces the null') -->replaces the null select coalesce(null,null,'replaces the null') --> ... And how it differs in MSSql. See Question&Answers more detail:os...

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

0 votes

407 views

1 answer

sql server - Error 0xc0202049: Data Flow Task 1: Failure inserting into the read-only column

I am using SQL Server 2008 import and export wizard. I need to import a database. I opened the SQL server ... force these values to be imported? See Question&Answers more detail:os...

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

0 votes

259 views

1 answer

sql - Is there a C# IN operator?

In SQL, you can use the following syntax: SELECT * FROM MY_TABLE WHERE VALUE_1 IN (1, 2, 3) Is there an ... myValue == 3) // Do something See Question&Answers more detail:os...

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

0 votes

270 views

1 answer

sql - MySQL statement combining a join and a count?

I've got a table of 'folders'. I want to return all the records with the userId of 16. SELECT * FROM ` ... combine these? I'm lost. Thanks! See Question&Answers more detail:os...

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

0 votes

349 views

1 answer

sql - MySQL: FULL OUTER JOIN - How do I merge one column?

I have a question regarding a FULL OUTER JOIN in MySQL. I have two (or more tables): table1 table2 id value id ... suggestions on how to do it? See Question&Answers more detail:os...

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

0 votes

390 views

1 answer

sql - Update values in identity column

How do I override the identity column in MSSQL? I tried : SET IDENTITY_INSERT GeoCountry ON UPDATE GeoCountry ... identity column 'CountryID'. See Question&Answers more detail:os...

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

0 votes

351 views

1 answer

sql - Force index use in Oracle

I encountered this question in an interview and had no clue how to answer: There is a table which has a index ... the query to use the index? See Question&Answers more detail:os...

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

0 votes

459 views

1 answer

sql - PostgreSQL calculate difference between rows

I tried to calculate difference between rows in a field using a query: Illustrations: input:year,month,fixes output ... adjacent rows in fixes. See Question&Answers more detail:os...

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

0 votes

488 views

1 answer

sql server express localdb.msi offline installer

I am not able to install with online installer. Can anyone point me where I can find the offline installer. I ... (might be due to firewall) See Question&Answers more detail:os...

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

0 votes

249 views

1 answer

sql server - How can I create a SQL unique constraint based on 2 columns?

I have a Table like this one: |UserId | ContactID | ContactName ---------------------------- ... I create a unique contraints across 2 columns? See Question&Answers more detail:os...

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

0 votes

593 views

1 answer

sql server - How can I remove accents on a string?

I have the following string áéíóú which I need to convert it to aeiou How can I achieve it? (I don't need to ... I need the new string to save) See Question&Answers more detail:os...

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

0 votes

368 views

1 answer

sql - Rails includes with conditions

Is is possible in Rails > 3.2 to add conditions to the join statement generated by the includes method? Let' ... are deprecated since 3.1. See Question&Answers more detail:os...

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

0 votes

368 views

1 answer

sql server - SQL Join Table Naming Convention

I have 2 tables: Users and Roles, and I have a table that joins these together. The only thing ... Name TableThatJoinsTheTwo: Id UserId RoleId See Question&Answers more detail:os...

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

0 votes

347 views

1 answer

sql - DBCC CHECKIDENT Sets Identity to 0

I'm using this code to reset the identity on a table: DBCC CHECKIDENT('TableName', RESEED, 0) This works ... will use new_reseed_value + 1. " See Question&Answers more detail:os...

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

0 votes

414 views

1 answer

sql - Watching variables in SSIS during debug

I have a project in SSIS and I've added an Execute SQL Task which sends its result out to a variable. I ... doing that. Thanks for any insight! See Question&Answers more detail:os...

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

0 votes

420 views

1 answer

sql - MySQL: Curdate() vs Now()

What is difference between MySQL Curdate() and Now()? See Question&Answers more detail:os...

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

0 votes

404 views

1 answer

sql - How to delete from a table where ID is in a list of IDs?

if I have a list of IDs (1,4,6,7) and a db table where I want to delete all records where ID is in this list, what is the way to do that? See Question&Answers more detail:os...

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

0 votes

610 views

1 answer

sql - I don't understand Collation? (Mysql, RDBMS, Character sets)

I Understand Character sets but I don't understand Collation. I know you get a default collation with every Character ... you in advance ;-) See Question&Answers more detail:os...

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

0 votes

427 views

1 answer

sql server - Connection between MSSQL and PHP 5.3.5 on IIS is not working

I recently installed IIS, PHP 5.3.5 and MySQL, and had it all working. I then has a requirement for MS ... my last attempt, can anyone help? See Question&Answers more detail:os...

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

0 votes

188 views

1 answer

sql - Why can't I simply add an index that includes all columns?

I have a table in SQL Server database which I want to be able to search and retrieve data from as fast as ... will grow larger than it needed to See Question&Answers more detail:os...

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

0 votes

234 views

1 answer

sql - Order items in MySQL by a fixed list?

I am going to have a fixed list of items to order by that I won't know until I run the query since ... maybe a find_in_set but not really sure. See Question&Answers more detail:os...

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

0 votes

561 views

1 answer

sql - Insert if not exists Oracle

I need to be able to run an Oracle query which goes to insert a number of rows, but it also checks to see ... to do this in PostgreSQL or MySQL. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags