Recent questions tagged SQL

0 votes

398 views

1 answer

sql - "SELECT DISTINCT" ignores different cases

I have the problem, that MSSQL Server 2000 should select some distinct values from a table (the specific column ... How to solve this problem? See Question&Answers more detail:os...

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

0 votes

318 views

1 answer

sql server 2008 - How to count in SQL all fields with null values in one record?

Is there any way to count all fields with null values for specific record excluding PrimaryKey column? ... explicitly specifying column names. See Question&Answers more detail:os...

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

0 votes

455 views

1 answer

sql - SHOW ALL Dates data between two dates; if no row exists for particular date then show zero in all columns

I want to show all dates between two dates when there is any date data missing then its should show zero in ... =0 SQL FIDDLE WITH SAMPLE DATA See Question&Answers more detail:os...

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

0 votes

393 views

1 answer

sql server - SQL injection: isn't replace("'", "''") good enough?

While I can certainly see the advantages of using parameters for SQL queries, especially when dealing with ... SQL injection with this. See Question&Answers more detail:os...

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

0 votes

411 views

1 answer

sql server - Are primary keys passé?

What unique functionality do Primary Keys provide? While i titled the question with tongue firmly planted in cheek, my ... to defining a PK. See Question&Answers more detail:os...

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

0 votes

426 views

1 answer

sql - How to use a dynamic parameter in a IN clause of a JPA named query?

my problem is about this kind of query : select * from SOMETABLE where SOMEFIELD in ('STRING1','STRING2'); the ... : JPA version 1.0 Oracle 11G See Question&Answers more detail:os...

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

0 votes

673 views

1 answer

sql - Oracle: Updating a table column using ROWNUM in conjunction with ORDER BY clause

I want to populate a table column with a running integer number, so I'm thinking of using ROWNUM. However, ... iteration method in PL/SQL? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - How to count date difference excluding weekend and holidays in MySQL

I need to count days (business days) between two dates excluding weekend (most important) and holidays SELECT DATEDIFF(end_date ... 51, 6, ''); See Question&Answers more detail:os...

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

0 votes

420 views

1 answer

sql server - Commas within CSV Data

I have a CSV file which I am directly importing to a SQL server table. In the CSV file each column is ... SQL server. What should I do? See Question&Answers more detail:os...

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

0 votes

453 views

1 answer

sql server - Set database collation in Entity Framework Code-First Initializer

I want to set the default collation for a database, when Entity Framework Code First creates it. I've tried ... can set the collation please? See Question&Answers more detail:os...

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

0 votes

446 views

1 answer

sql server - INFORMATION_SCHEMA vs sysobjects

In SQL Server: What is the difference between INFORMATION_SCHEMA and sysobjects? Does one provide more information ... difference between these? See Question&Answers more detail:os...

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

0 votes

701 views

1 answer

sql server - Date range overlapping check constraint

I've a simple table in sql server 2005 with 3 columns: DateStart, DateEnd and Value. I tried to set a ... range and DateEnd excludes from range. See Question&Answers more detail:os...

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

0 votes

511 views

1 answer

sql server - How to get only numeric column values?

Using SQL Server 2005 I want to get only numeric values from the table Column1 12345 asdf 2312 ase acd ... ... value Need SQL Server Query help See Question&Answers more detail:os...

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

0 votes

726 views

1 answer

sql - The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range?

I am working on application contains a datepicker and if I set the time in that picker to a very old ... The statement has been terminated. See Question&Answers more detail:os...

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

0 votes

455 views

1 answer

sql - How do I extract Month and Year in a MySQL date and compare them?

How do I extract the month and date from a mySQL date and compare it to another date? I found this MONTH() ... . I looking for month and year. See Question&Answers more detail:os...

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

0 votes

599 views

1 answer

sql - Excel VBA: writing to mysql database

I would like to write a macro in Excel that will write to a mysql database. Can someone please get me started on this? See Question&Answers more detail:os...

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

0 votes

401 views

1 answer

sql - When I call PreparedStatement.cancel() in a JDBC application, does it actually kill it in an Oracle database?

I have Java JDBC application running against an Oracle 10g Database. I set up a PreparedStatement to execute a ... bowels of Oracle? Thanks! See Question&Answers more detail:os...

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

0 votes

560 views

1 answer

sql - Prepared Statement on Postgresql in Rails

Right now I am in the middle of migrating from SQLite to Postgresql and I came across this problem. The ... doing wrong? Thanks in advance! See Question&Answers more detail:os...

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

0 votes

371 views

1 answer

sql - ORA-22905 - when querying a table type with a select statement

DECLARE TYPE record_AB IS RECORD ( AA VARCHAR2 (16 BYTE), BB VARCHAR2 (16 BYTE) ); TYPE type_tab_AB IS TABLE ... a table type within PLSQL? See Question&Answers more detail:os...

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

0 votes

518 views

1 answer

sql - Select latest row for each group from oracle

I have a table with user comments in a guestbook. Columns are: id, user_id, title, comment, timestamp. I need ... . How can this be done? See Question&Answers more detail:os...

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

0 votes

475 views

1 answer

sql - MySQL GROUP BY DateTime +/- 3 seconds

Suppose I have a table with 3 columns: id (PK, int) timestamp (datetime) title (text) I have the ... the nature of the server software. See Question&Answers more detail:os...

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

0 votes

567 views

1 answer

sql server - Perform regex (replace) in an SQL query

What is the best way to replace all '&lt' with < in a given database column? Basically perform s/&lt[^;]/</gi ... up with <;;;;;;;;;) See Question&Answers more detail:os...

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

0 votes

429 views

1 answer

sql - MySQL equivalent of Oracle's SEQUENCE.NEXTVAL

I need to be able to generate run a query that will return the next value of ID on the following table: ... done in one query the better. See Question&Answers more detail:os...

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

0 votes

387 views

1 answer

sql - Mysql Duplicate Rows ( Duplicate detected using 2 columns )

How to remove duplicated in this setup? id A B ---------------- 1 apple 2 2 orange 1 3 apple 2 4 ... what I need ? Many thanks for your replies. See Question&Answers more detail:os...

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

0 votes

339 views

1 answer

sql server - migrate data from MS SQL to PostgreSQL?

I've looked around and can't seem to find anything that answers this specific question. What is the simplest ... although free is preferable :) See Question&Answers more detail:os...

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

0 votes

452 views

1 answer

sql server - How to insert Arabic characters into SQL database?

How can I insert Arabic characters into a SQL Server database? I tried to insert Arabic data into a ... characters into SQL Server database? See Question&Answers more detail:os...

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

0 votes

442 views

1 answer

sql - "Order By" using a parameter for the column name

We would like to use a parameter in the "Order By" clause of a query or stored procedure created with ... expression referencing a column name. See Question&Answers more detail:os...

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

0 votes

318 views

1 answer

sql server - Removing duplicate rows (based on values from multiple columns) from SQL table

I have following SQL table: AR_Customer_ShipTo +--------------+------------+--------------- ... ', which only allows me to write queries.] See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags