Recent questions tagged SQL

0 votes

372 views

1 answer

sql - How to change the primary key to be non-clustered?

Part-time reluctant DBA here. I want to change an existing primary key index from clustered to non-clustered. ... statement in the online docs. See Question&Answers more detail:os...

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

0 votes

363 views

1 answer

sql - Efficient way to update all rows in a table

I have a table with a lot of records (could be more than 500 000 or 1 000 000). I added a new column ... which update the table row by row. See Question&Answers more detail:os...

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

0 votes

392 views

1 answer

sql - How to correctly do upsert in postgres 9.5

correct syntax of upsert with postgresql 9.5, below query shows column reference "gallery_id" is ambiguous error , why? var ... 1 | 3 | ... See Question&Answers more detail:os...

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

0 votes

386 views

1 answer

sql - Executing a stored procedure within a stored procedure

I would like to execute a stored procedure within a stored procedure, e.g. EXEC SP1 BEGIN EXEC SP2 END But I ... SP1 AS BEGIN EXECUTE SP2 END See Question&Answers more detail:os...

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

0 votes

361 views

1 answer

sql - MSSQL Select statement with incremental integer column... not from a table

I need, if possible, a t-sql query that, returning the values from an arbitrary table, also returns a ... must run on SQL Server 2000 See Question&Answers more detail:os...

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

0 votes

392 views

1 answer

sql - Selecting by month in PostgreSQL

I want to select rows according to the month of a date or timestamp column like this: SELECT id, name,?birthday ... . How can this be done? See Question&Answers more detail:os...

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

0 votes

392 views

1 answer

sql server - set default schema for a sql query

Is there a way to set the schema for a query so that in the rest of the query I can refer to tables ... select * from [schemaName].[tableName] See Question&Answers more detail:os...

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

0 votes

431 views

1 answer

sql - Using PIVOT and JOIN together

Consider This Query: SELECT [Order Details].OrderID, c.CategoryName, COUNT(c.CategoryID) FROM [Order Details] INNER ... I can do this? Thanks See Question&Answers more detail:os...

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

0 votes

366 views

1 answer

sql - MYSQL: Sequential Number Table

I am trying to get a sequential number table from 1 to 20 million. (or 0 to 20 million) I am rather awestruck at how ... ---+------------+ See Question&Answers more detail:os...

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

0 votes

381 views

1 answer

sql - Mysql mulitple row insert-select statement with last_insert_id()

Ok. So the short of it is, I was trying to do an INSERT SELECT such as: START TRANSACTION; INSERT INTO ... a dump and manually editing it? See Question&Answers more detail:os...

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

0 votes

536 views

1 answer

sql server - How is SqlException Number assigned

SqlException has the property Number. Then there is this: http://msdn.microsoft.com/en-us/library/cc645603.aspx and this: ... on both) ...... See Question&Answers more detail:os...

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

0 votes

530 views

1 answer

sql server - Sum of child levels total in a Hierarchy

I need to have each level be the sum of all children (in the hierarchy) in addition to any values set against ... to work in SQL Server 2008R2. See Question&Answers more detail:os...

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

0 votes

438 views

1 answer

sql server 2005 - How to split a string in T-SQL?

I have a varchar @a='a|b|c|d|e|f|g|h|i|j|k|l|m|n|o|p', which has | delimited values. I want to split ... a array or a table. How can I do this? See Question&Answers more detail:os...

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

0 votes

506 views

1 answer

sql server - C# / SQL Listener to tell me if a row has been inserted into a table

Can someone post sample code or tell me how to set up a listener to notify me (trigger an event) if a new ... do the same for a database table. See Question&Answers more detail:os...

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

0 votes

377 views

1 answer

sql - Oracle: getting maximum value of a group?

Given a table like this, what query will the most recent calibration information for each monitor? In other words, I ... 17 2 2012/01/02 19 See Question&Answers more detail:os...

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

0 votes

437 views

1 answer

sql - hierarchical sum in PostgreSQL

This is a simplified version of a problem I am encountering in PostgreSQL. I have the following ... utilizing PostgreSQL-specific extensions? See Question&Answers more detail:os...

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

0 votes

516 views

1 answer

sql server - Current transaction ID in an audit trigger

I was looking at storing some form of transaction id from an audit trigger. The solution appeared to be to ... is impersonating a database user. See Question&Answers more detail:os...

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

0 votes

399 views

1 answer

sql server - How can I make "month" columns in Sql?

I've got a set of data that looks something like this (VERY simplified): productId Qty dateOrdered --------- -- ... , but this guy is dog slow. See Question&Answers more detail:os...

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

0 votes

636 views

1 answer

sql - MySQL Nested Sets - How to find parent of node?

I have your run of the mill nested set hierarchy type setup with the following columns: table name: myset ... moving anything within the set. See Question&Answers more detail:os...

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

0 votes

370 views

1 answer

sql - How do I generate a series of hourly averages in MySQL?

I've got data in ten minutes intervals in my table: 2009-01-26 00:00:00 12 2009-01-26 00:10:00 1.1 2009-01 ... it should return: 5.42 8.87 etc. See Question&Answers more detail:os...

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

0 votes

637 views

1 answer

sql - Select statement in SQLite recognizing row number

I want to write SQLite statement something like this: SELECT * FROM Table WHERE RowNumber BETWEEN 1 AND 10; ... bookmarks please share. Thanks. See Question&Answers more detail:os...

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

0 votes

634 views

1 answer

sql - Joining 100 tables

Assume that I have a main table which has 100 columns referencing (as foreign keys) to some 100 tables ( ... Normalizing an extremely big table See Question&Answers more detail:os...

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

0 votes

402 views

1 answer

sql server - Repeatable Read - am I understanding this right?

Trying to completely understand SQL Server Isolation Levels - notably REPEATABLE READ. I have a sproc that starts a transaction ... is - am I?! See Question&Answers more detail:os...

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

0 votes

317 views

1 answer

sql - Using same column multiple times in WHERE clause

I have a following table structure. USERS PROPERTY_VALUE PROPERTY_NAME USER_PROPERTY_MAP I am trying to retrieve user/ ... missing 'property2'. See Question&Answers more detail:os...

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

0 votes

329 views

1 answer

sql server - Sql serve Full Text Search with Containstable is very slow when Used in JOIN!

I am using sql 2008 full text search and I am having serious issues with performance depending on how I use ... be fast. Any ideas? Thanks See Question&Answers more detail:os...

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

0 votes

395 views

1 answer

sql server - How to get node name and values from an xml variable in t-sql

I have the following xml - <Surveys xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi: ... in SQL Server 2008 R2? See Question&Answers more detail:os...

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

0 votes

733 views

1 answer

sql - Store multiple elements in json files in AWS Athena

I have some json files stored in a S3 bucket , where each file has multiple elements of same structure. For ... element of the map? Thanks. See Question&Answers more detail:os...

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

0 votes

436 views

1 answer

sql - PostgreSQL - best way to return an array of key-value pairs

I'm trying to select a number of fields, one of which needs to be an array with each element of the array ... ?) Any help is much appreciated. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags