Recent questions tagged SQL

0 votes

829 views

1 answer

Trying to import data into Azure. Created a text file in Management Studio 2005. I have tried both a comma ... the version of management studio. See Question&Answers more detail:os...

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

0 votes

562 views

1 answer

sql server - Rows showing as #DELETED

I have rows of data in a table showing as #DELETED on one computer when using Access but they are fine in both ... ideas for a fix for this? See Question&Answers more detail:os...

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

0 votes

504 views

1 answer

sql - RODBC loses time values of datetime when result set is large

So this is VERY strange. RODBC seems to drop the time portion of DateTime SQL columns if the result set ... query, which is downright strange. See Question&Answers more detail:os...

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

0 votes

525 views

1 answer

sql server - Retrieving the most recent records within a query

I have the following tables: tblPerson: PersonID | Name --------------------- 1 | John Smith 2 ... to happen to produce the desired result? See Question&Answers more detail:os...

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

0 votes

841 views

1 answer

sql - How To Set Server Output On in DataGrip

How Can I "set server output" on in Jetbrains DataGrip IDE? I am able to do this in SQL Developer and ... advice would be appreciated. Thanks. See Question&Answers more detail:os...

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

0 votes

530 views

1 answer

sql server - SQL Select 'n' records without a Table

Is there a way of selecting a specific number of rows without creating a table. e.g. if i use the following: ... , I want 10 New Rows. Thanks See Question&Answers more detail:os...

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

0 votes

562 views

1 answer

sql server - problem with WHERE clause matching on Arabic string

I have a SQL Server 2005 database in which I have some tables contain Arabic text. The datatype for those fields ... on how to write the query? See Question&Answers more detail:os...

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

0 votes

585 views

1 answer

sql - mysql execution time

Is there a way to get the execution time of the last executed query in mysql? See Question&Answers more detail:os...

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

0 votes

614 views

1 answer

sql - What is the difference between oracle's 'yy' and 'rr' date mask?

Example: select ename from emp where hiredate = todate('01/05/81','dd/mm/yy') and select ename from emp ... dd/mm/rr') return different results See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - Postgres "missing FROM-clause entry" error on query with WITH clause

I am trying to use this query in Postgres 9.1.3: WITH stops AS ( SELECT citation_id, rank() OVER (ORDER ... WITH clause, I get correct results. See Question&Answers more detail:os...

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

0 votes

525 views

1 answer

sql - Combine varchar column with int column

I have two columns in a SQL table, fooId (int) and fooName (varchar). Is there a way to select them both as one ... I'm a bit of a sql beginner) See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql - Determine ROW that caused "unexpected end of file" error in BULK INSERT?

i am doing a bulk insert: DECLARE @row_terminator CHAR; SET @row_terminator = CHAR(10); -- or char(10) ... problem and error occurs after that See Question&Answers more detail:os...

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

0 votes

555 views

1 answer

sql - How to give a unique constraint to a combination of columns in Oracle?

I have a Table with 4 Columns Each Column will be A,B,C,D Column A is the Primary key. Column B ... the combination of unique key constraint. See Question&Answers more detail:os...

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

0 votes

559 views

1 answer

sql - Command for adding a default constraint

There appears to be at least two ways to add a default constraint using straight T-SQL. Am I correct that the only ... ((1)) FOR [Active]; See Question&Answers more detail:os...

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

0 votes

827 views

1 answer

sql server 2008 - How to return values from a dynamic SQL Stored Procedure to the Entity Framework?

I have a Stored Procedure which executes some dynamic SQL. I want to use this Stored Procedure in entity ... values to the entity framework. See Question&Answers more detail:os...

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

0 votes

798 views

1 answer

sql - create table permission denied in database 'master'

I have installed the free version of sql server 2008 (sql server management studio express edition) on my PC. After ... to create a new login. See Question&Answers more detail:os...

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

0 votes

835 views

1 answer

sql - Inserting Image Into BLOB Oracle 10g

I am trying to insert an image into an BLOB field in a signatures which i will then select from the table ... see the image being displayed. See Question&Answers more detail:os...

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

0 votes

466 views

1 answer

sql server - SQL why is SELECT COUNT(*) , MIN(col), MAX(col) faster then SELECT MIN(col), MAX(col)

We're seeing a huge difference between these queries. The slow query SELECT MIN(col) AS Firstdate, MAX( ... columns fixes the performance issue. See Question&Answers more detail:os...

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

0 votes

531 views

1 answer

sql - How to create an "on-the-fly" mapping table within a SELECT statement in Postgresql

I'm creating a select statement that combines two tables, zone and output, based on a referenced device table ... the application side. Thanks! See Question&Answers more detail:os...

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

0 votes

567 views

1 answer

sql server - Entity Framework: How to properly handle exceptions that occur due to SQL constraints

I use Entity Framework to access my SQL data. I have some constraints in the database schema and I wonder how to ... to have them in the DB. See Question&Answers more detail:os...

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

0 votes

532 views

1 answer

sql - PostgreSQL: between with datetime

I use PostgreSQL 8.4.11 and find strange error. When I query: SELECT "documents_document"."given_on" FROM "documents_document" ... ... 1-12-31. See Question&Answers more detail:os...

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

0 votes

541 views

1 answer

sql - Easiest way to copy a MySQL database?

Does anyone know of an easy way to copy a database from one computer to a file, and then import it on another computer? See Question&Answers more detail:os...

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

0 votes

778 views

1 answer

sql - Cumulating value of current row + sum of previous rows

How would you do to transform a Column in a table from this: ColumnA ColumnB 2 a 3 b 4 c 5 d 1 a to ... to see esp. what method you would pick. See Question&Answers more detail:os...

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

0 votes

621 views

1 answer

sql server - SQL join format - nested inner joins

I have the following SQL statement in a legacy system I'm refactoring. It is an abbreviated view for the ... AND Table2.Key2 = Table3.Key2 See Question&Answers more detail:os...

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

0 votes

597 views

1 answer

sql - Get 0 value from a count with no rows

I have SELECT: SELECT c FROM ( SELECT "candidate_id" as id, count("candidate_id") as c FROM "Applicaions" ... ? Should I create any indexes? See Question&Answers more detail:os...

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

0 votes

505 views

1 answer

sql - How to check for duplicates in mysql table over multiple columns

I have a table of baseball players(all 1000 or so), with fields: mysql> describe person; +------- ... of a particular firstname, lastname combo? See Question&Answers more detail:os...

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

0 votes

626 views

1 answer

sql - PostgreSQL: Create table if not exists AS

I'm using PostgreSQL and am an SQL beginner. I'm trying to create a table from a query, and if I run: CREATE ... " Is there any way to do this? See Question&Answers more detail:os...

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

0 votes

526 views

1 answer

sql - MySQL Counting Distinct Values on Multiple Columns

I wrote a script that runs each time a user logs into a computer in our domain. This script makes a record ... looping some php? (booooo!) See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags