Recent questions tagged SQL

0 votes

1.3k views

1 answer

sql - Len function on Float in SQLServer gives wrong length

I am using the below query in SQL Server. declare @dt float set @dt = 1079938.05 select @dt AS Val,Convert( ... it shows 12 instead of 10. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql server - xp_regread() returned error 5, 'Access is denied.'

I'm running the SQL Server Copy Database Wizard. Of note is that the Operator is NT AUTHORITYSYSTEM, which ... the Import-Export Wizard failed. See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql - Slow LEFT JOIN on CTE with time intervals

I am trying to debug a query in PostgreSQL that I've built to bucket market data in time buckets in ... would my indexing strategy change? See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql - SSIS transformation (almost like a pivot)

I have the following data coming in to SSIS Set Value --- ------- 1 One 1 Two 1 Three 2 Four 2 Five 2 Six ... , Six How do I do this in SSIS? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - INSERT or SELECT strategy to always return a row?

Using Postgres 9.6, I have followed the strategy recommended in https://stackoverflow.com/a/40325406/435563 to do an ... i = 1 as expected. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - Getting Unavailable dates for renting a product that has stocks

Database queries, normally so simple, yet sometimes so difficult. (brain trainer) So I have products, stocks and ... ,@endDate))) >= @days See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql server - How do I select a regex match from a text/varchar in MS SQL?

I need to extract something from a long piece of text across lots of db rows, in a Microsoft SQL Server ... regex here" answer. Anyone ideas? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql - Auto increment Alphanumeric ID in MSSQL

I have an existing Stored procedure that generate employee ID. The employee ID have a format of EPXXXX, ... (@NewEmployeeID, @EmployeeName) END See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - Getting extra rows - After joing the 3 tables using Left Join

SELECT (b.descr || ' - ' || c.descr) description FROM tbl1 a LEFT JOIN tbl2 b ON a.ACCOUNT = b.ACCOUNT ... help me in this? thanks in advance See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql - "Not a valid month" on an INSERT statement

I have an sql statement: Insert into MYSCHEMA.TABLE1 (ID,MY_DATE) values (167600,to_timestamp('15-APR-14 ... Database 11b Express Edition. 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 - Does sqlserver collation mean column names must be correct case? And how to deal with that

In SQL Server (2000 or 2005) is it possible to set the database or server collation so that identifier names ... not use the application with? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql - android update database column based on the current column value

In android, SQLiteDatabase has a update function update(String table, ContentValues values, String whereClause, String[] ... num of row updated See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql - Strange SQL2005 problem. "SqlConnection does not support parallel transactions"

I have a problem that seems like its a result of a deadlock-situation. Whe are now searching for the root ... stupid things there. Without luck. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql server 2005 - Error Handling in Classic Asp without timeout error

In classic asp page, i need to catch the error description and insert into a table in the database. when ... exception and insert into database. 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 - How to write update query to update two tables with SQL Data Source?

Is it possible to update two tables using SQL Data Source and ASP.NET Grid View? I have the ... /UpdateParameters> </asp:SqlDataSource> See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql - How to turn 2 queries with common columns (A, B) and (A, C) into just one (A, B, C)?

I currently have 2 queries that return PRODUCER FirstQueryColumn ------------------------------ ---- ... .name; or am I doing something wrong? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql - Create a ROLLING sum over a period of time in mysql

I have a table with columns date and time_spent. I want to find for each date D the sum of the values of 'time_spent' ... -09-10 | 1 | 21 ... See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql - firebird isql: "there is no table XXXX in this database"

I am trying to extract data from a Firebird 2.5 SQL database for migration. The data has been built up over a ... , if this is possible at all. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - syntax error (missing operator) in query expression in MS Access

I'm getting the error: syntax error (missing operator) in query expression '((dbo_tblBidder.bidder_sale_id ... SumOfitem_premiums Thanks Gareth! See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql server - SQL find sets with common members (relational division)

I have separate sets of "classes" and "groups", each of which has been assigned one or more tags. I would ... with common tags in a defined set See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - Insert identity column value into table from another table?

create table #test (a int identity(1,1), b varchar(20), c varchar(20)) insert into #test (b,c) values (' ... from .... (thousand of records) - See Question&Answers more detail:os...

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

0 votes

1.7k views

1 answer

sql - Java SQLite : no such column error

I'm writing a Java app which has to add a record to a database. Everything works fine until I want to add ... main(Console.java:72) Thanks, Tom See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql server - sqlsrv drivers slow in codeigniter?

I have installed the latest version of CI 2.1.3 Now after running a query, I am getting a very slow response time ... is not a lot we can do. See Question&Answers more detail:os...

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

0 votes

16.4k views

1 answer

sql - Can I define multiple events in one Trigger declaration in mysql?

Here is my requirement, I have a mysql table on which any change (insert/delete/update) should be handled ... sophisticated solution for this ?? See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql - MySQL Multiple Counts in Single Query

I am trying to COUNT two columns in a single query, but the results are spitting out the same ... $tbl_members.lastname, $tbl_members.firstname; See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

sql - How to create a 4-4-5 fiscal calendar using python?

I would like to have a dataframe consisting of the corresponding week numbers and month every date from 1/1/21 to ... for all the help :) See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql - Oracle errors handling

I have such code: DECLARE e_not_exist EXCEPTION; PRAGMA EXCEPTION_INIT(e_not_exist, -942); car_name VARCHAR2(20); ... I handle this exception? See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql server - Scope of SET ANSI_WARNINGS OFF

if I have SET ANSI_WARNINGS OFF in one stored procedure to get rid of a warning, it only takes effects of ... of these settings with me. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags