Recent questions tagged SQL

0 votes

740 views

1 answer

sql - Split function-returned record into multiple columns

In a basic Postgres function tutorial there is an example with OUT parameters like so: create or replace function ... into the from section? See Question&Answers more detail:os...

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

0 votes

822 views

1 answer

sql server - Pessimistic lock in T-SQL

If i SELECT a row for updating in MS SQL Server, and want to have it locked till i either update or cancel, ... any other option. Thanks, Chak. See Question&Answers more detail:os...

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

0 votes

930 views

1 answer

sql - Python: Cannot concatenate str and NoneType objects

sql = """ INSERT INTO [SCHOOLINFO] VALUES( '""" + self.accountNo + """', '""" + self.altName + ... , and any help would be greatly appreciated. See Question&Answers more detail:os...

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

0 votes

811 views

1 answer

sql server - Comma Delimited SQL string Need to separated

I have this string that i am getting from .net application A,B,C,D,E,F, I wanted to write a sql select ... there any ways i can do this? See Question&Answers more detail:os...

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

0 votes

827 views

1 answer

sql - Remove duplicate from a table

The database type is PostGres 8.3. If I wrote: SELECT field1, field2, field3, count(*) FROM table1 GROUP BY field1 ... . The PK is the 3 fields. See Question&Answers more detail:os...

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

0 votes

845 views

1 answer

sql - Convert VARCHAR2 into Number

I have a table with a column named duration. Its data type is VARCHAR2. I want to sum the column duration. 00 ... using ANSI SQL or Oracle SQL? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql - Update multiple columns in MERGE statement ORACLE

I want to update multiple columns in MERGE statement,but for each column the conditions are different.How can I achieve ... END); COMMIT; END; / See Question&Answers more detail:os...

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

0 votes

755 views

1 answer

sql - Easiest way to get a total count and a count of a subset?

I was trying to do this: SELECT COUNT(*), ( SELECT COUNT(*) FROM attend WHERE (DATEPART(WEEKDAY,start_date) = 2 ... a better way to do this? See Question&Answers more detail:os...

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

0 votes

704 views

1 answer

sql server - Sort Order of results for Select WITHOUT WHERE or ORDER BY Clause

I have a table with a PK clustered index as well as other indexes on it, both unique and non-unique. If ... . All comments welcome. Thanks, Raj See Question&Answers more detail:os...

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

0 votes

737 views

1 answer

sql - Performance in PDO / PHP / MySQL: transaction versus direct execution

I am looping through a number of values (1 to 100 for example) and executing a prepared statement inside the loop ... from that point of view. See Question&Answers more detail:os...

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

0 votes

847 views

1 answer

sql, sqlite SELECT with inner join

I'm wondering how to select one column twice using an inner joinor some other way. my database is sqlite and ... id How to join this selection? See Question&Answers more detail:os...

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

0 votes

844 views

1 answer

sql - Informix: Select null problem

Using Informix, I've created a tempory table which I am trying to populate from a select statement. After this, ... " with no table specified!) See Question&Answers more detail:os...

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

0 votes

826 views

1 answer

sql - detect mysql errors without executing it

Suppose I make a query "UPDATE table SET etc etc" Then I "Execute" this query if the query is fine, it ... the event that there is no error? See Question&Answers more detail:os...

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

0 votes

775 views

1 answer

sql - Combine rows when the end time of one is the start time of another (Oracle)

I just can't seem to get this query figured out. I need to combine rows of time-consecutive states into a single ... ,52,50); Thanks in advance! See Question&Answers more detail:os...

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

0 votes

887 views

1 answer

sql server, cascade delete and parent/child table

i have one simple table with following columns: id, name and parentID i created relationship diagram between ... delete without triggers? See Question&Answers more detail:os...

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

0 votes

768 views

1 answer

sql - Foreign Key for either-or column?

Is it possible to have a foreign key that requires either column A or column B to have a value, but not both. ... for column B matches Table 2? See Question&Answers more detail:os...

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

0 votes

823 views

1 answer

sql server - Why NULL values are mapped as 0 in Fact tables?

What is the reason that in measure fields in fact tables (dimensionally modeled data warehouses) NULL values are usually mapped as 0? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql server - What does FixedLenNullInSource in sp_help mean?

Taking a look around FixedLenNullInSource is for compatibility with SQL 2000, but what does it actually mean? See Question&Answers more detail:os...

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

0 votes

860 views

1 answer

sql - Computed column should result to string

Here is a snap of my database. Both col1 and col2 are declared as int. My ComputedColumn currently adds the ... what is the correct syntax? See Question&Answers more detail:os...

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

0 votes

769 views

1 answer

sql - How to programmatically check if row is deletable?

Say we have a PostgreSQL table like so: CREATE TABLE master ( id INT PRIMARY KEY, ... ); and many other ... of new child row is denied. See Question&Answers more detail:os...

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

0 votes

738 views

1 answer

sql - Select columns from one table based on the column names from another table

I have 2 tables, one that contains the final results I need, and another that contains the list of ... , end_date, contract from table_results See Question&Answers more detail:os...

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

0 votes

891 views

1 answer

sql - using dynamic IN clause in MSSQL

Why the following SQL does not fetch me anything DECLARE @Status AS VARCHAR(400) SET @status = '''Closed'',''OPEN ... ','Open') fetches me rows See Question&Answers more detail:os...

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

0 votes

912 views

1 answer

sql server - SQL - Returning all rows even if count is zero for item

I am performing a count based on a date range. Currently the query does return the correct result but I ... direction I'd appreciate it. See Question&Answers more detail:os...

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

0 votes

762 views

1 answer

sql - Delete records within Instead Of Delete trigger

I want to have an instead of delete trigger so that I can get text field values out of the table row that's ... to save into a new record? See Question&Answers more detail:os...

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

0 votes

653 views

1 answer

sql - Unable to query named range on sheet with spaces in name in Excel

I have a workbook with multiple sheets, and each sheet has the same set of named ranges (IE they are scoped ... (at least) 2 different machines. See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

sql - UNNEST expression references column which is neither grouped nor aggregated

Google Analytics BigQuery tables are structured like this (Legacy SQL notations - only relevant fields are shown): ... as the first one? See Question&Answers more detail:os...

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

0 votes

691 views

1 answer

sql - Select items like records from a column in another table

I have a table (foo) with a large number of several records and I only want to select those that are like ... a column in a different table? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - removing milliseconds from a oracle tmstmp field

I have a TIMESTAMP(6) field in Oracle and I need to remove the millisecond component from the time. For example I ... way to do this? Thank you! See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags