Recent questions tagged SQL

0 votes

331 views

1 answer

sql - How do I make Java & Postgres enums work together for update?

acttype is an enumcs so you can't insert it as a normal string without casting it to an enumcs INSERT ... enumcs,national_code=? where actcode=? See Question&Answers more detail:os...

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

0 votes

357 views

1 answer

sql server - Find Column dependency

How to find objects which depend on particular column of table. Ex: Table: SomeTable Cols: col1 pk, col2, col3 I ... are dependent on col1 (Pk) See Question&Answers more detail:os...

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

0 votes

330 views

1 answer

sql - Which one have better performance : Derived Tables or Temporary Tables

Sometimes we can write a query with both derived table and temporary table. my question is that which one is better? why? See Question&Answers more detail:os...

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

0 votes

631 views

1 answer

sql server - How to copy views from one database to another database

I have two databases with same structure in MS SQL server. I'd like to copy all views another database. I tried ... of views & number of copies! See Question&Answers more detail:os...

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

0 votes

508 views

1 answer

sql - Android - sqlite in clause using values from array

I want to execute a sqlite query: select * from table_name where id in (23,343,33,55,43); The values in the in ... "43"} How can I achieve that? See Question&Answers more detail:os...

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

0 votes

344 views

1 answer

sql - What is the equivalent of 'go' in MySQL?

In TSQL I can state: insert into myTable (ID) values (5) GO select * from myTable In MySQL I can't write ... way to write this query in MySQL? See Question&Answers more detail:os...

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

0 votes

347 views

1 answer

sql server - How to convert records in a table to xml format using T-SQL?

I've got a simple table and want to store its content into a xml on the harddrive. There should be one root ... do I have? Thanks a lot Tomas See Question&Answers more detail:os...

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

0 votes

576 views

1 answer

sql - How to insert a unique ID into each SQLite row?

I have the following SQLite code. How do I insert an auto generating unique ID into each row? tx.executeSql('DROP TABLE ... (2, "Second row")'); See Question&Answers more detail:os...

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

0 votes

321 views

1 answer

sql - Search a whole table in mySQL for a string

I'm trying to search a whole table in mySQL for a string. I want to search all fields and all entrees of a ... * FROM `clients` IN 'Mary' See Question&Answers more detail:os...

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

0 votes

493 views

1 answer

sql - count without group

I have one table named GUYS(ID,NAME,PHONE) and i need to add a count of how many guys have the same ... of guys with different counts. thanks See Question&Answers more detail:os...

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

0 votes

271 views

1 answer

sql server - How can I copy data records between two instances of an SQLServer database

I need to copy some records from our SQLServer 2005 test server to our live server. It's a flat lookup ... directly between the two instances. See Question&Answers more detail:os...

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

0 votes

700 views

1 answer

sql server - Cannot get rid of "physical connection is not usable" exception

I am about to shoot myself. Spent few weeks now trying to solve this issue. We have an ASP.NET MVC 4 ... - Physical connection is not usable) See Question&Answers more detail:os...

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

0 votes

480 views

1 answer

sql - GROUP BY and COUNT in PostgreSQL

The query: SELECT COUNT(*) as count_all, posts.id as post_id FROM posts INNER JOIN votes ON votes.post_id ... this context right in PostgreSQL? See Question&Answers more detail:os...

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

0 votes

275 views

1 answer

sql - BETWEEN clause versus <= AND >=

Is there a performance difference between using a BETWEEN clause or using <= AND >= comparisons? i.e. these two ... ) with an index on it. See Question&Answers more detail:os...

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

0 votes

309 views

1 answer

sql - How to select the comparison of two columns as one column in Oracle

I cannot figure out how to add a column to my SELECT query indicating whether two columns contain the same data ... correct syntax to do this? See Question&Answers more detail:os...

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

0 votes

340 views

1 answer

sql server - Unique Constraint vs Unique Index

I'm interested in learning which technique developers prefer to use to enforce uniqueness in SQL Server: UNIQUE ... one or the other? See Question&Answers more detail:os...

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

0 votes

389 views

1 answer

sql - Which is better: Bookmark/Key Lookup or Index Scan

I know that an index seek is better than an index scan, but which is preferable in SQL Server explain plans: ... again for SQL Server 2008... See Question&Answers more detail:os...

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

0 votes

359 views

1 answer

sql - join on multiple columns

I have two tables (Table A and Table B) which I want to join on multiple columns in both tables. Table A Col1 ... Col2 in Table B to get Val. See Question&Answers more detail:os...

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

0 votes

375 views

1 answer

sql - Change Primary Key

I have a table in Oracle which has following schema: City_ID Name State Country BuildTime Time When I declared the ... I change the primary key? See Question&Answers more detail:os...

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

0 votes

601 views

1 answer

sql - PostgreSQL: FOREIGN KEY/ON DELETE CASCADE

I have two tables like here: DROP TABLE IF EXISTS schemas.book; DROP TABLE IF EXISTS schemas.category; DROP ... still populated, what's wrong? See Question&Answers more detail:os...

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

0 votes

397 views

1 answer

sql - MySQL Long Query Progress Monitoring

Just to preface my question, I understand that there is no direct support for something like this. What I am ... of progress would be ideal. See Question&Answers more detail:os...

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

0 votes

348 views

1 answer

sql - Oracle insert from select into table with more columns

I want to insert to a table from a select statement, however, there are 3 columns returned from the select ... query for that? Thank you! See Question&Answers more detail:os...

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

0 votes

538 views

1 answer

sql - CREATE FILE encountered operating system error 5(failed to retrieve text for this error. Reason: 15105)

I have a database file .mdf from MS SQL EXPRESS in folder: C:Program FilesMicrosoft SQL ServerMSSQL10.SQLEXPRESSMSSQLDATA ... how to solve it? See Question&Answers more detail:os...

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

0 votes

523 views

1 answer

sql server - Why can't I use "create schema" in a begin/end block in SQL Management Studio?

I generated a script which creates all users and schemas for this database and when I wrap the CREATE statements ... ] AUTHORIZATION [dbo] END See Question&Answers more detail:os...

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

0 votes

445 views

1 answer

sql server - Boolean 'NOT' in T-SQL not working on 'bit' datatype?

Trying to perform a single boolean NOT operation, it appears that under MS SQL Server 2005, the following block ... . Am I missing something? See Question&Answers more detail:os...

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

0 votes

653 views

1 answer

sql server - The target principal name is incorrect. Cannot generate SSPI context

I am struggling to get a SQL Server connection from machine A to machine B which is running the SQL Server. I ... just tell me what you need. See Question&Answers more detail:os...

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

0 votes

348 views

1 answer

sql - Custom post type yearly/ monthly archive

I have a custom post type "news" in my Wordpress site. I am using Advanced Custom Fields plugin to add meta ... unsure how to make this happen? See Question&Answers more detail:os...

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

0 votes

570 views

1 answer

sql - How can I speed up row_number in Oracle?

I have a SQL query that looks something like this: SELECT * FROM( SELECT ..., row_number() OVER(ORDER BY ... more time with the EXPLAIN tool? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags