Recent questions tagged SQL

0 votes

399 views

1 answer

sql - How to find consecutive rows based on the value of a column?

I have some data. I want to group them based on the value of data column. If there are 3 or more consecutive rows ... :00.000 19 How to do that? See Question&Answers more detail:os...

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

0 votes

281 views

1 answer

sql server - Why execute stored procedures is faster than SQL query from a script?

In fact, if I call the stored procedures from my application, I need a connection to my DB. So, why calling ... query" string to be executed? See Question&Answers more detail:os...

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

0 votes

338 views

1 answer

sql - How do I pass a list as a parameter in a stored procedure?

Looking to pass a list of User IDs to return a list names. I have a plan to handle the outputed names ... @user_id_list is my main concern here. See Question&Answers more detail:os...

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

0 votes

253 views

1 answer

sql server - How to set value to variable using 'execute' in t-sql?

DECLARE @dbName nvarchar(128) = 'myDb' DECLARE @siteId int exec ('SELECT TOP 1 @siteId = Id FROM ' + @dbName + ... and how to fix it? Thank you See Question&Answers more detail:os...

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

0 votes

277 views

1 answer

sql - Best way to model Customer <--> Address

Every Customer has a physical address and an optional mailing address. What is your preferred way to model this? ... . What are your thoughts? See Question&Answers more detail:os...

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

0 votes

225 views

1 answer

sql server - How to build RUNAS /NETONLY functionality into a (C#/.NET/WinForms) program?

Our workstations are not members of the domain our SQL Server is on. (They're not ... use LOGON_NETCREDENTIALS_ONLY with CreateProcessWithLogonW See Question&Answers more detail:os...

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

0 votes

249 views

1 answer

sql - How to delete in MS Access when using JOIN's?

I am attempting to use the DELETE clause in MS Access and have an issue when also using the JOIN clause. I ... the JET engine to require this? See Question&Answers more detail:os...

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

0 votes

313 views

1 answer

sql - Count Number of Consecutive Occurrence of values in Table

I have below table create table #t (Id int, Name char) insert into #t values (1, 'A'), (2, 'A'), ( ... Id but it doesn't give me expected result See Question&Answers more detail:os...

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

0 votes

225 views

1 answer

sql - How to set a MySQL row to READ-ONLY?

I have a row in a table that I do not want to be changed (ever). Is it possible to set a MySQL row to ... be changed? If so, how? Thanks. See Question&Answers more detail:os...

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

0 votes

276 views

1 answer

sql - How to LOAD DATA INFILE in mysql with first col being Auto Increment?

Currently, We have a table similar to this: --------------------- ID | AField | ... work) 0,afieldvalue,bfieldvalue NULL,afieldvalue,bfieldvalue See Question&Answers more detail:os...

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

0 votes

304 views

1 answer

sql - How can I determine the status of a job?

I have a Stored procedure which schedules a job. This Job takes a lot of time to get completed (approx 30 ... in between because of any error. See Question&Answers more detail:os...

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

0 votes

227 views

1 answer

sql server - How can I know when SQL Full Text Index Population is finished?

We are writing unit tests for our ASP.NET application that run against a test SQL Server database. That ... find anything in the documentation. See Question&Answers more detail:os...

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

0 votes

449 views

1 answer

sql - MySQL : ERROR 1215 (HY000): Cannot add foreign key constraint

I have read Database system concepts, 6th edition, Silberschatz. I'm going to implement the university database ... add foreign key constraint See Question&Answers more detail:os...

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

0 votes

219 views

1 answer

sql - Select rows where column value has changed

Let's say I have the following table: Value Time 0 15/06/2012 8:03:43 PM 1 15/06/2012 8:03:43 PM ... increasing Value is OK if that is easier. See Question&Answers more detail:os...

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

0 votes

369 views

1 answer

sql - How to quote a string value explicitly (Python DB API/Psycopg2)

For some reasons, I would like to do an explicit quoting of a string value (becoming a part of constructed ... write such function myself... See Question&Answers more detail:os...

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

0 votes

210 views

1 answer

sql - Set value to NULL in MySQL

I want a value to be set to NULL if nothing is put into the text box in the form I'm submitting. How can ... I'm just writing an UPDATE query. See Question&Answers more detail:os...

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

0 votes

439 views

1 answer

sql - How to add 'ON DELETE CASCADE' in ALTER TABLE statement

I have a foreign key constraint in my table, I want to add ON DELETE CASCADE to it. I have tried ... constraint already exists in the table See Question&Answers more detail:os...

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

0 votes

243 views

1 answer

sql - Sleep function in ORACLE

I need execute an SQL query in ORACLE it takes a certain amount of time. So I wrote this function: ... using the DBMS_LOCK.sleep function? See Question&Answers more detail:os...

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

0 votes

421 views

1 answer

sql - Detect overlapping date ranges from the same table

I have a table with the following data PKey Start End Type ==== ===== === ==== 01 01/01/2010 14/01/ ... on matching days, is this the only way? See Question&Answers more detail:os...

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

0 votes

272 views

1 answer

sql server - WHERE clause better execute before IN and JOIN or after

I read this article: Logical Processing Order of the SELECT statement in end of article has been write ON ... with top article? thanks See Question&Answers more detail:os...

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

0 votes

304 views

1 answer

sql - MYSQL select DISTINCT values in two columns

I want to select distinct values in a database. Let me run you through a quick example. Table: foo bar -- ... from both columns, please help! See Question&Answers more detail:os...

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

0 votes

286 views

1 answer

sql - How to Alter Constraint

SQL How to Alter Constraint Below is 1 of my constraint CONSTRAINT ACTIVEPROG_FKEY1 FOREIGN KEY(ActiveProgCode) ... is at Table ACTIVEPROG See Question&Answers more detail:os...

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

0 votes

220 views

1 answer

sql - String concatenation does not work in SQLite

I am trying to execute a SQlite replace function, but use another field in the function. select locationname + '<p>' ... and the '<p>' literals. See Question&Answers more detail:os...

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

0 votes

667 views

1 answer

sql - How to compare the current row with next and previous row in PostgreSQL?

I want to know how to retrieve results in a SQL query doing some logic comparison with the next or previous rows ... about them, but never used. See Question&Answers more detail:os...

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

0 votes

246 views

1 answer

sql server - Executing set of SQL queries using batch file?

I am using a SQL Server database. I have these SQL queries: Delete from TableA; Delete from TableB; Delete ... is a remote database. Thanks! See Question&Answers more detail:os...

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

0 votes

440 views

1 answer

sql - Must declare the scalar variable

@RowFrom int @RowTo int are both Global Input Params for the Stored Procedure, and since I am compiling the SQL ... @Rt and generates an error. See Question&Answers more detail:os...

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

0 votes

294 views

1 answer

sql server - Aggregate function in an SQL update query?

I'm trying to set the value in one table to the sum of the values in another table. Something along these ... blank. What am I doing wrong? See Question&Answers more detail:os...

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

0 votes

448 views

1 answer

sql - Storing IPv6 Addresses in MySQL

As has been requested in "ipv6-capable inet_aton and inet_ntoa functions needed", there is currently no MySQL function ... into 2 INT's. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags