Recent questions tagged SQL

0 votes

461 views

1 answer

sql - Prevent recursive CTE visiting nodes multiple times

Consider the following simple DAG: 1->2->3->4 And a table, #bar, describing this (I'm using SQL Server ... even with the suggested predicate. :( See Question&Answers more detail:os...

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

0 votes

364 views

1 answer

sql server 2008 - Drop All constraints in a Table

Am trying to write script for removing Constraints. I have the below function to select the Constarints in my ... easy ways I can proceed? See Question&Answers more detail:os...

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

0 votes

309 views

1 answer

sql server 2005 - What is a deadlock in a database?

What is a deadlock in SQL Server and when it arises? What are the issues with deadlock and how to resolve it? See Question&Answers more detail:os...

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

0 votes

293 views

1 answer

sql server 2005 - Point to localhostsqlexpress using only localhost

Working on a common codebase, one developer is running SQL Server Express 2005 and the other 2 are running SQL ... =True If at all possible. See Question&Answers more detail:os...

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

0 votes

406 views

1 answer

sql - Java Iterator backed by a ResultSet

I've got a class that implements Iterator with a ResultSet as a data member. Essentially the class looks like this: ... I'd like to avoid this. See Question&Answers more detail:os...

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

0 votes

842 views

1 answer

sql server - MS SQL creating many-to-many relation with a junction table

I'm using Microsoft SQL Server Management Studio and while creating a junction table should I create an ID column ... key or identity table] ? See Question&Answers more detail:os...

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

0 votes

566 views

1 answer

sql - How can I insert multiple rows into oracle with a sequence value?

I know that I can insert multiple rows using a single statement, if I use the syntax in this answer. ... just use multiple INSERT statements. See Question&Answers more detail:os...

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

0 votes

543 views

1 answer

sql - Executing a stored procedure inside BEGIN/END TRANSACTION

If I create a Stored Procedure in SQL and call it (EXEC spStoredProcedure) within the BEGIN/END TRANSACTION, does ... like try/catches in C#. See Question&Answers more detail:os...

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

0 votes

321 views

1 answer

sql - Why do multiple-table joins produce duplicate rows?

Let's say I have three tables A, B, and C. Each has two columns: a primary key and some other piece of ... myself and avoiding it in the future. See Question&Answers more detail:os...

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

0 votes

407 views

1 answer

sql - How to compare two SQLite databases on Linux

Using Linux, I want to compare two SQLite databases that have the same schema. There will be just a few differences ... SQL tool might also do. See Question&Answers more detail:os...

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

0 votes

413 views

1 answer

sql - Python: Number of rows affected by cursor.execute("SELECT ...)

How can I access the number of rows affected by: cursor.execute("SELECT COUNT(*) from result where server_state='2' ... +"_"+charset+"_%'") See Question&Answers more detail:os...

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

0 votes

337 views

1 answer

sql - Use one CTE many times

I have this, and i get an error at set total. Why can't i access a cte many times? ALTER PROCEDURE [dbo ... ( SELECT COUNT(*) FROM CTEPlayers ) See Question&Answers more detail:os...

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

0 votes

408 views

1 answer

sql server - Get structure of temp table (like generate sql script) and clear temp table for current instance

How do I get structure of temp table then delete temp table. Is there a sp_helptext for temp tables? ... tempdb..sp_help #myTempTable Reference. See Question&Answers more detail:os...

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

0 votes

497 views

1 answer

sql - Postgres: Add constraint if it doesn't already exist

Does Postgres have any way to say ALTER TABLE foo ADD CONSTRAINT bar ... which will just ignore the command if ... it doesn't raise an error? See Question&Answers more detail:os...

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

0 votes

380 views

1 answer

sql - Representing ecommerce products and variations cleanly in the database

I have an ecommerce store that I am building. I am using Rails/ActiveRecord, but that really isn't necessary to ... ways I could be doing this? See Question&Answers more detail:os...

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

0 votes

337 views

1 answer

sql - Composite vs Surrogate keys for Referential Integrity in 6NF

Take three layers of information: Layer 1: Information This layer contains data with UNIQUE natural indexes and a ... END EDIT Thank you! See Question&Answers more detail:os...

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

0 votes

346 views

1 answer

sql - Database structure for storing historical data

Preface: I was thinking the other day about a new database structure for a new application and realized that we ... 't feasible in this case. See Question&Answers more detail:os...

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

0 votes

294 views

1 answer

sql - python sqlite3, how often do I have to commit?

I have a for loop that is making many changes to a database with a sqlite manager class I wrote, but I am ... after I have made both changes? See Question&Answers more detail:os...

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

0 votes

294 views

1 answer

sql - How to migrate an existing Postgres Table to partitioned table as transparently as possible?

I have an existing table in a postgres-DB. For the sake of demonstration, this is how it looks like: ... migrate my table to be partitioned? See Question&Answers more detail:os...

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

0 votes

492 views

1 answer

sql server - How to disable Constraints for all the tables and enable it?

I have 60 tables. I want to drop 10 tables where these 10 tables are Constraints(PK,FK) to other 20 tables. ... I want to know smarter method. See Question&Answers more detail:os...

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

0 votes

368 views

1 answer

sql server - MS SQL Date Only Without Time

Question Hello All, I've had some confusion for quite some time with essentially flooring a DateTime SQL type ... still a better practice. See Question&Answers more detail:os...

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

0 votes

305 views

1 answer

sql - GROUP BY but get all values from other column

I''ll explain what I need to do on example. First of all, we have a simple table like this one, named table: ... , foobar 2 | foo, bar, foobar See Question&Answers more detail:os...

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

0 votes

727 views

1 answer

sql - Inserting text string with hex into PostgreSQL as a bytea

I have a text file with several strings of hex in it: 013d7d16d7ad4fefb61bd95b765c8ceb 007687fc64b746569616414b78c81ef1 I ... things wrong? See Question&Answers more detail:os...

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

0 votes

396 views

1 answer

sql - When to use an auto-incremented primary key and when not to?

I'm trying to figure out the "best practices" for deciding whether or not to add an auto-incrementing integer ... containing each person's SSN? See Question&Answers more detail:os...

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

0 votes

356 views

1 answer

sql - Query to check index on a table

I need a query to see if a table already has any indexes on it. See Question&Answers more detail:os...

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

0 votes

291 views

1 answer

sql server - What's the difference between a Primary Key and Identity?

In a SQL Server db, what is the difference between a Primary Key and an Identity column? A column can be a ... just a PK column doesn't? See Question&Answers more detail:os...

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

0 votes

419 views

1 answer

sql - MySQL: How to add one day to datetime field in query

In my table I have a field named eventdate in datetime format like 2010-05-11 00:00:00. How do i make ... select records with tomorrow's date. See Question&Answers more detail:os...

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

0 votes

268 views

1 answer

sql server - Tables with no Primary Key

I have several tables whose only unique data is a uniqueidentifier (a Guid) column. Because guids are non- ... columns to index that way? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags