Recent questions tagged SQL

0 votes

319 views

1 answer

sql - Why can't I use an alias in a DELETE statement?

In SQL Server Compact Edition in Visual Studio 2010 (maybe SQL Server and SQL in general, I don't know), this ... IN ('chickens', 'rabbits')) See Question&Answers more detail:os...

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

0 votes

269 views

1 answer

sql - Hierarchical/tree database for directories path in filesystem

I want to store the directories (present on the disk) into a database, maintaining their hierarchical/tree ... like ROOT/Dir2/Dir4/Dir7 See Question&Answers more detail:os...

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

0 votes

353 views

1 answer

sql - Why are batch inserts/updates faster? How do batch updates work?

Why are batch inserts faster? Is it because the connection and setup overhead for inserting a single row is the ... part of the SQL standard? See Question&Answers more detail:os...

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

0 votes

335 views

1 answer

sql - Using DISTINCT and COUNT together in a MySQL Query

Is something like this possible: SELECT DISTINCT COUNT(productId) WHERE keyword='$keyword' What I want is to get ... be counted per product ID See Question&Answers more detail:os...

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

0 votes

325 views

1 answer

sql - IN vs. JOIN with large rowsets

I'm wanting to select rows in a table where the primary key is in another table. I'm not sure if I should use a JOIN ... a JOIN b ON a.c = b.d See Question&Answers more detail:os...

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

0 votes

359 views

1 answer

sql - How to find out what is locking my tables?

I have a SQL table that all of a sudden cannot return data unless I include with (nolock) on the end, which ... I'm using SQL Server 2008 R2. See Question&Answers more detail:os...

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

0 votes

260 views

1 answer

sql server - SQL update trigger only when column is modified

By looking at other examples I've come up with the following but it doesn't seem to work as I would like ... S.QtyToRepair <> I.QtyToRepair END See Question&Answers more detail:os...

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

0 votes

407 views

1 answer

sql - What does ON [PRIMARY] mean?

I'm creating an SQL setup script and I'm using someone else's script as an example. Here's an example of ... the ON [PRIMARY] command does? See Question&Answers more detail:os...

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

0 votes

388 views

1 answer

sql - Oracle 'Partition By' and 'Row_Number' keyword

I have a SQL query written by someone else and I'm trying to figure out what it does. Can someone please ... bit too depth. Thanks in advance! See Question&Answers more detail:os...

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

0 votes

323 views

1 answer

sql - row-level trigger vs statement-level trigger

I am having a hard time understanding the difference between 'row-level triggers' and 'statement-level triggers'. ... an example of the two? See Question&Answers more detail:os...

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

0 votes

265 views

1 answer

sql - How would I implement a simple site search with php and mySQL?

I'm creating a site that allows users to submit quotes. How would I go about creating a (relatively simple?) ... my main concern is that.) See Question&Answers more detail:os...

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

0 votes

420 views

1 answer

sql server 2008 - Cannot open backup device. Operating System error 5

Below is the query that I am using to backup (create a .bak) my database. However, whenever I run it, I always ... NAME = 'Full Backup of MyDB'; See Question&Answers more detail:os...

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

0 votes

318 views

1 answer

sql server - Count number of records returned by group by

How do I count the number of records returned by a group by query, For eg: select count(*) from temptable group by ... to get 1+1+1 = 3. See Question&Answers more detail:os...

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

0 votes

601 views

1 answer

sql order by - SQL for ordering by number - 1,2,3,4 etc instead of 1,10,11,12

I'm attempting to order by a number column in my database which has values 1-999 When I use ORDER_BY registration_no ASC I ... 1,2,3,4,5,6 etc See Question&Answers more detail:os...

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

0 votes

536 views

1 answer

sql - The object 'DF__*' is dependent on column '*' - Changing int to double

Basically I got a table in my EF database with the following properties: public int Id { get; set; } public ... this column. What's the issue? See Question&Answers more detail:os...

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

0 votes

339 views

1 answer

sql server 2008 - Performance of bcp/BULK INSERT vs. Table-Valued Parameters

I'm about to have to rewrite some rather old code using SQL Server's BULK INSERT command because the schema ... responses as well. Thanks again! See Question&Answers more detail:os...

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

0 votes

315 views

1 answer

sql server - T-SQL query to show table definition?

What is a query that will show me the full definition, including indexes and keys for a SQL Server table? I ... the DDL that defines the table. See Question&Answers more detail:os...

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

0 votes

353 views

1 answer

sql server - How do you copy a record in a SQL table but swap out the unique id of the new row?

This question comes close to what I need, but my scenario is slightly different. The source table and destination table ... to know what it is. See Question&Answers more detail:os...

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

0 votes

269 views

1 answer

sql server - How do I move a table into a schema in T-SQL

I want to move a table into a specific Schema using T-SQL? I am using SQL Server 2008. See Question&Answers more detail:os...

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

0 votes

358 views

1 answer

sql - Inner Joining three tables

I have three tables I wish to inner join by a common column between them. Say my tables are; TableA TableB TableC I ... do I add the third one? See Question&Answers more detail:os...

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

0 votes

254 views

1 answer

sql - Is there a version control system for database structure changes?

I often run into the following problem. I work on some changes to a project that require new tables or columns ... MS SQL Server, then great. See Question&Answers more detail:os...

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

0 votes

296 views

1 answer

sql - Best way to store working hours and query it efficiently

I'm planning to store working hours for shops. I'm wondering what might be the best modeling for the working ... moment in very efficient way. See Question&Answers more detail:os...

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

0 votes

341 views

1 answer

sql - Comparison of Relational Databases and Graph Databases

Can someone explain to me the advantages and disadvantages for a relation database such as MySQL compared to a ... -conceptual reason for this? See Question&Answers more detail:os...

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

0 votes

263 views

1 answer

sql - How can I group by date time column without taking time into consideration

I have a bunch of product orders and I'm trying to group by the date and sum the quantity for that date. How ... grouped with 3/8/2010 4:15:00 See Question&Answers more detail:os...

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

0 votes

520 views

1 answer

sql - ALTER TABLE without locking the table?

When doing an ALTER TABLE statement in MySQL, the whole table is read-locked (allowing concurrent reads, but prohibiting ... ; that's just weak. See Question&Answers more detail:os...

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

0 votes

238 views

1 answer

sql - PostgreSQL - fetch the row which has the Max value for a column

I'm dealing with a Postgres table (called "lives") that contains records with columns for time_stamp, usr_id, transaction_id, ... ', 3, 3, 1); See Question&Answers more detail:os...

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

0 votes

307 views

1 answer

sql - Difference between FULL JOIN & INNER JOIN

What is the difference between a FULL JOIN and an INNER JOIN? When I do a FULL JOIN, I get 832 records and ... INNER JOIN, I get 830 records. See Question&Answers more detail:os...

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

0 votes

478 views

1 answer

sql - Find all records which have a count of an association greater than zero

I'm trying to do something that I thought it would be simple but it seems not to be. I have a project model ... ) AND (count(vacancies) > 0). See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags