Recent questions tagged SQL

0 votes

729 views

1 answer

sql - String list in SqlCommand through Parameters in C#

Working with a SqlCommand in C# I've created a query that contains a IN (list...) part in the where clause ... approach? Thanks for your time :) See Question&Answers more detail:os...

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

0 votes

563 views

1 answer

sql - Can MySQL use Indexes when there is OR between conditions?

I have two queries plus its own EXPLAIN's results: One: SELECT * FROM notifications WHERE id = 5204 OR seen ... me should I use which approach? See Question&Answers more detail:os...

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

0 votes

736 views

1 answer

sql server - How to set "Application Name" in ADODB connection string

In .NET I simply use Application Name = MyApp inside the connection string, but when using ADO connection ... name for monitoring purposes? See Question&Answers more detail:os...

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

0 votes

674 views

1 answer

sql server 2008 - SQL Count to include zero values

I have created the following stored procedure that is used to count the number of records per day between a ... issue. Thanks in advance Neil See Question&Answers more detail:os...

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

0 votes

706 views

1 answer

sql server: need to escape [?

I need to escape [ in an sql query for SQL Server select * from sometable where name like '[something]'; ... mark after the character string '; See Question&Answers more detail:os...

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

0 votes

662 views

1 answer

sql - Can I create Foreign Keys across Databases?

We have 2 databases - DB1 & DB2. Can I create a table in DB1 that has a relation with one of the tables ... -00942:Table or view does not exist See Question&Answers more detail:os...

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

0 votes

659 views

1 answer

sql server - Can SQL CLR triggers do this? Or is there a better way?

I want to write a service (probably in c#) that monitors a database table. When a record is inserted into ... ideas on how to accomplish this? See Question&Answers more detail:os...

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

0 votes

774 views

1 answer

sql - How do I SUM DISTINCT Rows?

I'm struggling with a query where I need to SUM DISTINCT Rows. There has to be a way to do ... Thanks everyone who contributed! Russell Schutte See Question&Answers more detail:os...

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

0 votes

568 views

1 answer

sql server - Detecting circular references in SQL

I have the following table: CREATE TABLE X ( A SOMETYPE NOT NULL, B SOMETYPE NOT NULL, C SOMETYPE NULL, PRIMARY ... am using SQL Server 2008 R2. See Question&Answers more detail:os...

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

0 votes

525 views

1 answer

sql - Update column based on matching values in other table in mysql

I have two tables calendar and customer table. Calendar table have a "customer" column which has customer ... . Customer Table calendar Table See Question&Answers more detail:os...

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

0 votes

647 views

1 answer

sql - Reset autonumber seed

I have a VB6/Access application that occasionally encounters a problem with wrong autonumber field seed. Lets say ... ideas for a solution? See Question&Answers more detail:os...

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

0 votes

624 views

1 answer

sql server - calculate fiscal year in sql select statement?

I have a date field that needs to return in fiscal year format. example Start_Date Year 04/01/2012 - 2013 01 ... we do that in select statement? See Question&Answers more detail:os...

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

0 votes

664 views

1 answer

sql server - Recordset Closed After Stored Procedure Execution

I'm executing a stored procedure using ADO in VBA. I'm trying to populate the recordset with the results from ... is being closed / not filled? See Question&Answers more detail:os...

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

0 votes

680 views

1 answer

sql - MS Access 2010: "Cannot open any more databases."

While struggling with a single legacy MS Access application I faced this weird error: Cannot open any more databases. ... rid of these unions? See Question&Answers more detail:os...

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

0 votes

624 views

1 answer

sql - JOIN versus EXISTS performance

Generally speaking, is there a performance difference between using a JOIN to select rows versus an EXISTS ... looking for coding guidance. See Question&Answers more detail:os...

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

0 votes

617 views

1 answer

sql server - Why does an UPDATE take much longer than a SELECT?

I have the following select statement that finishes almost instantly. declare @weekending varchar(6) set @weekending = ... a huge difference? See Question&Answers more detail:os...

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

0 votes

1.7k views

1 answer

sql - postgres syntax error at or near "ON"

I created this table: CREATE TABLE IF NOT EXISTS config_activity_log ( id serial primary key, activity_name ... ON CONFLICT (activity_name) See Question&Answers more detail:os...

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

0 votes

580 views

1 answer

sql - How to join two tables together with same number of rows by their order

I am using SQL2000 and I would like to join two table together based on their positions For example consider the ... in a T-SQL select?? See Question&Answers more detail:os...

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

0 votes

673 views

1 answer

sql - Update Oracle table with values from CSV file

I have a CSV file which contains an ID and several other columns. I also have a table in oracle where the ... a "real" program. Thanks, Thomas See Question&Answers more detail:os...

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

0 votes

643 views

1 answer

sql - Using OUTPUT clause to insert value not in INSERTED

I am writing a stored procedure to process a table belonging to an application and insert values into a table ... which lines I have processed? See Question&Answers more detail:os...

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

0 votes

765 views

1 answer

sql - HTML Format in sp_send_dbmail

I formatted sp_send_dbmail to send email in HTML format. But it is sending the mail with HTML code. Below ... , @profile_name = 'DBMailProfile1' See Question&Answers more detail:os...

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

0 votes

981 views

1 answer

sql - What's the asymptotic complexity of GroupBy operation?

I am interested in the asymptotic complexity (big O) of the GroupBy operation on unindexed datasets. What's the ... servers and LINQ are using? See Question&Answers more detail:os...

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

0 votes

955 views

1 answer

sql server - Microsoft´s sqlsrv driver for PHP not returning any result when querying "SELECT SCOPE_IDENTITY() AS id"

this query works fine using the php_mssql driver: INSERT INTO Table(columnName) VALUES ('text'); SELECT SCOPE_IDENTITY( ... 3 release... Thanks. See Question&Answers more detail:os...

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

0 votes

881 views

1 answer

sql - How do I solve "Keyword not supported: 'metadata' "?

I can't connect to SQL Server and connection string of my project is: <add name="Teleport_DEVEntities" connectionString ... I fix this error? See Question&Answers more detail:os...

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

0 votes

560 views

1 answer

sql - Find the date/time a table's column was created

How can you query SQL Server for the creation date for a SQL Server 2005 table column? I tried the sp_columns [ ... . How can this be done? See Question&Answers more detail:os...

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

0 votes

620 views

1 answer

sql - Simple recursive query in Oracle

I'm currently having some trouble understanding and writing recursive queries. I understand that recursive queries are ... ? Thanks in advance. See Question&Answers more detail:os...

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

0 votes

635 views

1 answer

sql - How to check performance of mysql query?

I have been learning query optimization, increase query performance and all but in general if we create a query ... would be in live database. See Question&Answers more detail:os...

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

0 votes

920 views

1 answer

sql - Performance of regexp_replace vs translate in Oracle?

For simple things is it better to use the translate function on the premise that it is less CPU ... within Oracle REGEXP_REPLACE function? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags