Recent questions tagged SQL

0 votes

452 views

1 answer

sql server 2005 - Selecting Nth Record in an SQL Query

I have an SQL Query that i'm running but I only want to select a specific row. For example lets say my ... that (similar to top). Thanks jack See Question&Answers more detail:os...

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

0 votes

362 views

1 answer

sql - Finding rows with consecutive increase in the values of a column

I have a sql table that stores the daily prices of stocks. New records are inserted every day after the market ... , please do let me know. See Question&Answers more detail:os...

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

0 votes

372 views

1 answer

sql - Deleting rows from parent and child tables

Assume two tables in Oracle 10G TableA (Parent) --> TableB (Child) Every row in TableA has several ... tableB where last_update_dtm=systdate-30 See Question&Answers more detail:os...

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

0 votes

408 views

1 answer

sql - Speed of paged queries in Oracle

This is a never-ending topic for me and I'm wondering if I might be overlooking something. Essentially I use ... of the ROWNUM pseudo-column? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql server 2005 - How can Hibernate map the SQL data-type nvarchar(max)?

I have a column in my SQL-2005 database that used to be a varchar(max), but it has been changed to an ... it treated string as a text type. See Question&Answers more detail:os...

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

0 votes

390 views

1 answer

sql server - How much overhead does 'Update Check' have for LINQ UPDATES

I have a simple row that I edit using LINQ. It has about 30 columns, including a primary key numeric sequence. When ... 1,@p11=30,@p12=6,@p13=6 See Question&Answers more detail:os...

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

0 votes

928 views

1 answer

sql - Why is executemany slow in Python MySQLdb?

I am developing a program in Python that accesses a MySQL database using MySQLdb. In certain situations, I have to ... it shouldn't do anything. See Question&Answers more detail:os...

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

0 votes

889 views

1 answer

sql - What is the best way to search the Long datatype within an Oracle database?

I am working with an Oracle database that stores HTML as a Long datatype. I would like to query the ... datatypes: expected NUMBER got LONG See Question&Answers more detail:os...

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

0 votes

423 views

1 answer

sql server 2008 - set @var = exec stored_procedure

Is it possible to assign at variable a value returned from exec stored procedure? Something like DECLARE @count ... dbo.usp_GetCount @Id=123 See Question&Answers more detail:os...

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

0 votes

438 views

1 answer

sql - How do you deal with m..n relationships in a relational database?

Let's look at an example - books. A book can have 1..n authors. An author can have 1..m books. What ... identified by the name on the cover? See Question&Answers more detail:os...

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

0 votes

374 views

1 answer

sql server 2005 - Deleting hierarchical data in SQL table

I have a table with hierarchical data. A column "ParentId" that holds the Id ("ID" - key column) of it's ... nesting). How to do it? Thanks See Question&Answers more detail:os...

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

0 votes

397 views

1 answer

sql - Is there a way to split the results of a select query into two equal halfs?

I need a solution for a select query in Sql Server 2005. I'd like to have a query returning two ... ton of where clauses and subqueries. See Question&Answers more detail:os...

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

0 votes

482 views

1 answer

sql - Postgresql generate_series of months

I'm trying to generate a series in PostgreSQL with the generate_series function. I need a series of months starting ... sure how to do months. See Question&Answers more detail:os...

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

0 votes

414 views

1 answer

sql server - SQL: Is there a possibility to convert numbers (1,2,3,4...) to letters (A,B,C,D...)

Is there a possibility to obtain letters (like A,B) instead of numbers (1,2) e.g. as a result of Dense_Rank function call(in MS Sql) ? See Question&Answers more detail:os...

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

0 votes

424 views

1 answer

sql - What’s the easiest way to preview data from an image column?

I have some columns with image data type and I want to preview (or browse) the data in those tables. When I ... data type is not an option. See Question&Answers more detail:os...

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

0 votes

311 views

1 answer

sql - "<>" vs "NOT IN"

I was debugging a stored procedure the other day and found some logic something like this: SELECT something ... between Server2005 and 2008? See Question&Answers more detail:os...

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

0 votes

386 views

1 answer

sql server - Attempted SQL injection attack - what are they trying to do?

I have a public facing website that has been receiving a number of SQL injection attacks over the last few weeks. ... EXEC" is attempting to do? See Question&Answers more detail:os...

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

0 votes

345 views

1 answer

sql - COUNT(*) Includes Null Values?

MSDN documentation states: COUNT(*) returns the number of items in a group. This includes NULL values and duplicates ... they're trying to make? See Question&Answers more detail:os...

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

0 votes

420 views

1 answer

sql server - What is the most efficient way to generate 8 character random alphanumeric string in TSQL?

I want to generate a unique 8 character random alphanumeric string in TSQL, for a mail confirm link. We ... be unique be generated efficiently See Question&Answers more detail:os...

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

0 votes

403 views

1 answer

sql - How to add a sequence column to an existing table with records

I had created a new table named USERLOG with two fields from a previous VIEW. The table already consist of about ... any help that I can get! See Question&Answers more detail:os...

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

0 votes

429 views

1 answer

sql - Conditional JOIN different tables

I want to know if a user has an entry in any of 2 related tables. Tables USER (user_id) EMPLOYEE (id, ... in both tables. SQL Fiddle example See Question&Answers more detail:os...

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

0 votes

565 views

1 answer

sql - In MySQL: How to pass a table name as stored procedure and/or function argument?

For instance, this does not work: DELIMITER // CREATE PROCEDURE countRows(tbl_name VARCHAR(40)) BEGIN SELECT COUNT( ... ? Is this even possible? See Question&Answers more detail:os...

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

0 votes

397 views

1 answer

sql - When to use an enum or a small table in a relational database?

I have a several small entities in my database that I represent as small table with two columns: id and name ... those entities doesn't matter? See Question&Answers more detail:os...

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

0 votes

505 views

1 answer

sql server - Why doesn't SSIS recognize line feed {LF} row delimiter while importing UTF-8 flat file?

I am trying to import data from a utf-8 encoded flat file into SQL Server 2008 using SSIS. This is what ... appreciate any help you can offer. See Question&Answers more detail:os...

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

0 votes

700 views

1 answer

sql - PostgreSQL 9.1: How to concatenate rows in array without duplicates, JOIN another table

I am using PostgreSQL 9.1 and need help with concatenating multiple rows in one. I need to do that in 2 tables. ... to do this, because of JOIN? See Question&Answers more detail:os...

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

0 votes

334 views

1 answer

sql - Postgres - CREATE TABLE FROM SELECT

I have two tables, one contains a large list of IDs and Info regarding those ids. I have a second table ... CREATE TABLE FROM SELECT? Thanks! See Question&Answers more detail:os...

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

0 votes

480 views

1 answer

sql - How to pass a temp table as a parameter into a separate stored procedure

I have a stored procedure that takes an input parameter @CategoryKeys varchar, and parses its contents into a temp ... to hold the temp table? See Question&Answers more detail:os...

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

0 votes

435 views

1 answer

sql - How to write subquery inside the OUTER JOIN Statement

I want to join two table CUSTMR and DEPRMNT. My needed is: LEFT OUTER JOIN OF two or more Tables with ... this query on my DB2 database. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags