Recent questions tagged SQL

0 votes

241 views

1 answer

sql - What column should the clustered index be put on?

Lately, I have been doing some reading on indexes of all types and the main advice is to put the clustered ... are only allowed one of them? See Question&Answers more detail:os...

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

0 votes

411 views

1 answer

sql - Maintaining subclass integrity in a relational database

Let's say I have a table that represents a super class, students. And then I have N tables that represent ... for your input, especially Bill. See Question&Answers more detail:os...

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

0 votes

248 views

1 answer

sql server - Update existing database with Entity Framework Code First in MVC

In my MVC application I used Entity Framework 6 and created database with code first approach. After a certain time, ... ("dbo.City"); } See Question&Answers more detail:os...

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

0 votes

320 views

1 answer

sql server - Performance of COUNT SQL function

I have two choices when writing an SQL statement with the COUNT function. SELECT COUNT(*) FROM <table_name> SELECT ... gain by using option 1? See Question&Answers more detail:os...

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

0 votes

544 views

1 answer

sql - How to add offset in a "select" query in Oracle 11g?

How to add an offset in a "select" query in Oracle 11g. I only know how to add the limit by e.g rownum <= ... to add the offset in Oracle 11g ? See Question&Answers more detail:os...

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

0 votes

254 views

1 answer

sql - INSERT of 10 million queries under 10 minutes in Oracle?

I am working on a file loader program. The purpose of this program is to take an input file, do some conversions on its data and then upload ... --------------------- | 0 | INSE...

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

0 votes

563 views

1 answer

sql server 2008 - Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.OLE.Interop.IServiceProvider'

After installing Visual Studio 2008 and SQL Server 2008 on Windows 7, I get the following error when connecting ... how to resolve this issue? See Question&Answers more detail:os...

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

0 votes

298 views

1 answer

sql server - SQL replace all NULLs

I have a big table with some NULLs in it. What is the easiest possible way to select from the table with ... ISNULL(FieldName,0) AS FieldName. See Question&Answers more detail:os...

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

0 votes

863 views

1 answer

sql - Query for count of distinct values in a rolling date range

I have a data set of email addresses and dates that those email addresses were added to a table. There can be ... 05-08' group by test.date; See Question&Answers more detail:os...

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

0 votes

324 views

1 answer

sql - Like operator for integer

I have a column of type bigint (ProductSerial) in my table. I need to filter the table by the Product serial ... want to use the = operator). See Question&Answers more detail:os...

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

0 votes

286 views

1 answer

sql - Recursive query used for transitive closure

I've created a simple example to illustrate transitive closure using recursive queries in PostgreSQL. However, something is ... path[1],depth; See Question&Answers more detail:os...

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

0 votes

324 views

1 answer

sql - Counting rows for all tables at once

I'm using SQL Server 2005 and would like to know how I can get a list of all tables with the number of ... unable to find the count. Thank you See Question&Answers more detail:os...

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

0 votes

281 views

1 answer

sql - Custom ORDER BY to ignore 'the'

I'm trying to sort a list of titles, but currently there's a giant block of titles which start with 'The ' ... course the crux of the problem. See Question&Answers more detail:os...

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

0 votes

415 views

1 answer

sql server - SQL Updatable View with joined tables

I have a view that looks similar to this, SELECT dbo.Staff.StaffId, dbo.Staff.StaffName, dbo. ... any subsequently joined tables? See Question&Answers more detail:os...

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

0 votes

496 views

1 answer

sql - How to write UNION in Doctrine 2.0

How to write this SQL query in Doctrine 2.0 (and fetch results)? (SELECT 'group' AS type, CONCAT(u.firstname, " ... = e.id) ) ORDER BY created See Question&Answers more detail:os...

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

0 votes

241 views

1 answer

sql - Equals(=) vs. LIKE for date data type

First, I am aware that this question has been posted generally Equals(=) vs. LIKE. Here, I query about ... any explanation for this please ? See Question&Answers more detail:os...

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

0 votes

299 views

1 answer

sql - mysql group by and sort each group

I have the following table: ID NAME TIME 1 A 0 2 A 3 3 B 1 I am using the query below which produces: SELECT * ... ID NAME TIME 2 A 3 3 B 1 See Question&Answers more detail:os...

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

0 votes

441 views

1 answer

sql - Does SQLite3 have prepared statements in Node.js?

From the npm docs, only visible prepared statements are for insert. Does these prepared statement work for Select, ... hell unable to find any. See Question&Answers more detail:os...

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

0 votes

299 views

1 answer

sql server - Pass a variable into a trigger

I have a trigger which deals with some data for logging purposes like so: CREATE TRIGGER trgDataUpdated ON ... used for illustration purposes. See Question&Answers more detail:os...

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

0 votes

415 views

1 answer

sql - Is it possible to perform a bitwise group function?

I have a field in a table which contains bitwise flags. Let's say for the sake of example there are three flags: ... , does it work in oracle?) See Question&Answers more detail:os...

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

0 votes

357 views

1 answer

sql - Can I use non-aggregate columns with group by?

You cannot (should not) put non-aggregates in the SELECT line of a GROUP BY query. I would however like ... when it's calculating the max. See Question&Answers more detail:os...

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

0 votes

384 views

1 answer

sql server - Why to use "not null primary key" in TSQL?

I am seeing too frequently "not null primary key" in scripts creating tables in TSQL in blogs, articles, books, ... is scripted by SSMS for PK! See Question&Answers more detail:os...

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

0 votes

290 views

1 answer

sql - How can I search all columns in a table?

How can I search all columns of a table in SQL Server? See Question&Answers more detail:os...

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

0 votes

611 views

1 answer

sql server - pyodbc - very slow bulk insert speed

With this table: CREATE TABLE test_insert ( col1 INT, col2 VARCHAR(10), col3 DATE ) the following code ... statement bind all parameters execute See Question&Answers more detail:os...

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

0 votes

590 views

1 answer

sql - Return rows from INSERT with ON CONFLICT without needing to update

I have a situation where I very frequently need to get a row from a table with a unique constraint, and if ... more elegant way to do this? See Question&Answers more detail:os...

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

0 votes

427 views

1 answer

sql - DateDiff to output hours and minutes

my code gives TOTAL HOURS in hours, but i am trying to output something like TotalHours 8:36 where 8 ... times Order By EmplID, DateVisited See Question&Answers more detail:os...

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

0 votes

267 views

1 answer

sql server - How to include the total number of returned rows in the resultset from SELECT T-SQL command?

I would like to ask if there is a way to include the total number of rows, as an additional column, in ... the total number of resultset pages. See Question&Answers more detail:os...

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

0 votes

870 views

1 answer

sql - Windowed functions can only appear in the SELECT or ORDER BY clauses

Can anyone explain why can't we use windowed functions in group by clause and why it's allowed only in SELECT and ... 't we use it group by? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags