Recent questions tagged SQL

0 votes

332 views

1 answer

Using a PostgreSQL 8.4.14 database, I have a table representing a tree structure like the following example: CREATE TABLE unit ... 1 3 | 1 4 | 4 See Question&Answers more detail:os...

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

0 votes

431 views

1 answer

sql - SQLite multi-Primary Key on a Table, one of them is Auto Increment

I have multiple (composite) primary keys on a table and one of them will be auto increment. However, interestingly ... ). Any solutions to this? See Question&Answers more detail:os...

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

0 votes

654 views

1 answer

sql server - sp_executesql is slow with parameters

I'm using dapper-dot-net as an ORM and it produces the following, slow-executing (1700ms), SQL code. exec ... -32768 AND SensorValue != -32767' See Question&Answers more detail:os...

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

0 votes

390 views

1 answer

sql server - Split comma delimited string and insert to a table (int)

i have a table with 3 columns (First_ID,Second_ID,Third_ID) all columns are int columns. Now I have 3 values, ... as i want. Thanks in advance See Question&Answers more detail:os...

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

0 votes

523 views

1 answer

sql - Moving Average based on Timestamps in PostgreSQL

I wanted to perform moving average through timestamps. I have two columns: Temperature and timestamps (time- ... different sampling frequency. See Question&Answers more detail:os...

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

0 votes

775 views

1 answer

I'm trying to use the similarity function in Postgres to do some fuzzy text matching, however whenever I ... do something to initalize pg_trgm? See Question&Answers more detail:os...

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

0 votes

307 views

1 answer

sql - How to insert data into table using stored procedures in postgresql

CREATE TABLE app_for_leave ( sno integer NOT NULL, eid integer, ename varchar(20), sd date, ed date, sid ... a table using stored procedures? See Question&Answers more detail:os...

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

0 votes

860 views

1 answer

sql - Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 4 (Year)

I'm getting the conversion error when I try to import a text file to my database. Below is the error message I ... tell me how to fix this? See Question&Answers more detail:os...

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

0 votes

286 views

1 answer

sql server 2008 - How to find all SQL Agent Jobs that call a given stored-proc

I'm in SQL 2008/R2. I want to run a query to see if there is a SQL Agent job calling a specified ... there are too many to inspect manually). See Question&Answers more detail:os...

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

0 votes

346 views

1 answer

sql - MySQL FULLTEXT indexes issue

I'm trying to create a FULLTEXT index on an attribute of a table. Mysql returns ERROR 1214: The used table type ... idea what I'm doing wrong? See Question&Answers more detail:os...

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

0 votes

552 views

1 answer

sql server - SSMS 2016 Error Importing Azure SQL v12 bacpac: master keys without password not supported

I have done this dozens of times but just recently ran into this error. Here are the steps I have gone through to ... Edition (v13.0.1722.0). See Question&Answers more detail:os...

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

0 votes

388 views

1 answer

sql - Do link tables need a meaningless primary key field?

I am working on a couple of link tables and I got to thinking (Danger Will Robinson, Danger) what are ... disqualify this as a possible option? See Question&Answers more detail:os...

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

0 votes

347 views

1 answer

sql - Query across multiple databases on same server

I am looking for a way of dealing with the following situation: We have a database server with multiple databases ... find the correct info... See Question&Answers more detail:os...

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

0 votes

306 views

1 answer

sql - Fire a trigger after the update of specific columns in MySQL

In MySQL, I want to fire a trigger after the update of specific columns. I know how to do it in Oracle and ... END How to do that with MySQL? See Question&Answers more detail:os...

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

0 votes

323 views

1 answer

sql - psql: server closed the connection unexepectedly

I've been trying to run this batch file that goes through the Postgre DB Server and run two different sql ... database from that point on. See Question&Answers more detail:os...

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

0 votes

325 views

1 answer

sql - What is the data type for unix_timestamp (MySQL)?

What data type should I use for saving unix_timestamp value (MySQL)? See Question&Answers more detail:os...

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

0 votes

365 views

1 answer

sql - How do I rename an Index in MySQL

I would like to rename an index. I've looked at the alter table documentation, but I can't figure out the ... tool for editing the binary info. See Question&Answers more detail:os...

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

0 votes

429 views

1 answer

sql - Postgres recursive query with row_to_json

I've got a table in postgres 9.3.5 that looks like this: CREATE TABLE customer_area_node ( id bigserial NOT ... to do this with row_to_json? See Question&Answers more detail:os...

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

0 votes

398 views

1 answer

sql server 2005 - SQL Statement Help - Select latest Order for each Customer

Say I have 2 tables: Customers and Orders. A Customer can have many Orders. Now, I need to show any Customers ... no end of confusion to others. See Question&Answers more detail:os...

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

0 votes

477 views

1 answer

sql server - How to Create an Extension for SSMS 2019 (v18)

SQL Server Management Studio 18 RC1 became available March 28, 2018 This question has already been asked for SSMS ... an running in SSMS 2019? See Question&Answers more detail:os...

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

0 votes

232 views

1 answer

sql - Finding simultaneous events in a database between times

I have a database that stores phone call records. Each phone call record has a start time and an end time. ... I go about solving this problem? See Question&Answers more detail:os...

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

0 votes

537 views

1 answer

sql - Why even use *DB.exec() or prepared statements in Golang?

I'm using golang with Postgresql. It says here that for operations that do not return rows (insert, ... even bother using prepared statements? 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 keep only one row of a table, removing duplicate rows?

I have a table that has a lot of duplicates in the Name column. I'd like to only keep one row for each. The ... HAVING COUNT(*) > 1; Thank you. See Question&Answers more detail:os...

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

0 votes

241 views

1 answer

sql server - How to exclude records with certain values in sql select

How do I only select the stores that don't have client 5? StoreId ClientId ------- --------- 1 4 ... result in another query's EXISTS IN clause See Question&Answers more detail:os...

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

0 votes

272 views

1 answer

sql - Change column types in a huge table

I have a table in SQL Server 2008 R2 with close to a billion rows. I want to change the datatype of ... will actually lead to any improvement. See Question&Answers more detail:os...

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

0 votes

370 views

1 answer

sql - Split varchar into separate columns in Oracle

I'm in a bit of a pickle: I've been asked to take in comments starting with a specific string from a ... sake of splitting a string into two? See Question&Answers more detail:os...

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

0 votes

389 views

1 answer

sql server - How to ALTER the Table Value Parameter

I am not getting option like 'ALTER TO' when am right clicking on TVP See Question&Answers more detail:os...

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

0 votes

529 views

1 answer

sql server 2005 - newid() vs newsequentialid() What are the differences/pros and cons?

In a database where all of your primary keys are GUIDs, what are the differences/implications and/or pros ... table in an incremented fashion. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags