Recent questions tagged Sql

0 votes

306 views

1 answer

sql - Update multiple rows in a single MySQL query

I am trying to run this: UPDATE test SET col2=1 WHERE col1='test1', SET col2=3 WHERE col1='test2'; The error ... can I do this in one query? See Question&Answers more detail:os...

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

0 votes

343 views

1 answer

sql - Check if two "select"s are equivalent

Is there a way to check if two (non-trivial) select are equivalent? Initially I was hoping for a formally ... of two selects are the same. See Question&Answers more detail:os...

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

0 votes

436 views

1 answer

sql - varchar2(n BYTE|CHAR) default -> CHAR or BYTE

I am supporting code that has below schema declaration:- create table sample ( id number Primary key, username ... or 500 characters? thanks, See Question&Answers more detail:os...

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

0 votes

514 views

1 answer

sql - How does SELECT from two tables separated by a comma work? (SELECT * FROM T1, T2)

Given 2 tables T1 and T2. T1 T2 --------- A 1 B 2 C 3 You make a query: SELECT * FROM T1, T2 What is ... is : 9 Question: Why is the answer "9"? See Question&Answers more detail:os...

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

0 votes

333 views

1 answer

sql server - How to return default value from SQL query

Is there any easy way to return single scalar or default value if query doesn't return any row? At this ... better way without using IF-ELSE? See Question&Answers more detail:os...

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

0 votes

295 views

1 answer

sql - Why not use varchar(max)?

I'm a bit old school when it comes to database design, so I'm totally for using the correct data sizes in ... make him see the light :). See Question&Answers more detail:os...

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

0 votes

533 views

1 answer

sql server - SQL Coalesce with empty string

I have the following: Select Coalesce(Other,Industry) Ind from registration The thing is that Other can be ... Coalesce still returns Industry? See Question&Answers more detail:os...

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

0 votes

476 views

1 answer

sql server - Is there a way to suppress "x rows affected" in SQLCMD from the command line?

Is there a way to suppress "x rows affected" in SQLCMD from the command line? I'm running an MSBuild script ... line, that would be fantastic. See Question&Answers more detail:os...

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

0 votes

330 views

1 answer

sql server - SQL query to search for room availability

The follow tables I have are: CUSTOMERS (CustomerID, firstname, surname etc) ROOMS (RoomID, RoomType, ... same situation needing help. See Question&Answers more detail:os...

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

0 votes

385 views

1 answer

sql - Hamming Distance / Similarity searches in a database

I have a process, similar to tineye that generates perceptual hashes, these are 32bit ints. I intend to store ... of hashes. Any Ideas? See Question&Answers more detail:os...

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

0 votes

516 views

1 answer

sql - Running a stored procedure with NodeJS and MSSQL package error

Im trying to get the MSSQL nodejs package to return the results of a stored procedure from Microsoft SQL server using the ... , resp, err) } }; See Question&Answers more detail:os...

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

0 votes

239 views

1 answer

sql - How to view all the Metadata of columns of a table in oracle database?

I want to know the Query that allows us to view all the columns that are defined for a table in oracle ... that are defined for any column. See Question&Answers more detail:os...

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

0 votes

397 views

1 answer

sql - Rollback a committed transaction

Is there any way to rollback a committed transaction in oracle 11g I have made a delete from table in db and ... there any way to do it? See Question&Answers more detail:os...

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

0 votes

288 views

1 answer

sql - Do DDL statements always give you an implicit commit, or can you get an implicit rollback?

If you're halfway through a transaction and perform a DDL statement, such as truncating a table, then the ... DDL and a commit after. See Question&Answers more detail:os...

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

0 votes

598 views

1 answer

sql - How to split comma separated text in MySQL stored procedure

How to split comma separated text (list of IDs) in MySQL stored procedure to use result in SQL "IN" ... (commaSeparatedData, ',')); See Question&Answers more detail:os...

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

0 votes

293 views

1 answer

sql - Passing dynamic order by in stored procedure

I am creating below stored procedure. declare @PageNum as Int declare @PerPageResult as Int declare @StartDate as ... then name end DESC See Question&Answers more detail:os...

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

0 votes

513 views

1 answer

sql server - radius search by latitude / longitude

I have found a bunch of answers for this question using mysql , but I wasn't able to convert anything into a query ms sql ... ) ) < ( 5 *5 ); See Question&Answers more detail:os...

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

0 votes

272 views

1 answer

sql - Is it possible to monitor and log actual queries made against an Access MDB?

Is it possible to monitor what is happening to an Access MDB (ie. what SQL queries are being executed ... of actual queries being called. See Question&Answers more detail:os...

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

0 votes

376 views

1 answer

sql server 2005 - How to concatenate columns properly using T-SQL?

I have a address in more than one column in a table. SELECT FirstName, LastName, StreetAddress, City, Country, ... me the best practice? Thanks See Question&Answers more detail:os...

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

0 votes

355 views

1 answer

sql - Optimizing MySQL LIKE '%string%' queries in innoDB

Having this table: CREATE TABLE `example` ( `id` int(11) unsigned NOT NULL auto_increment, `keywords` varchar(200 ... this for innoDB ? Thanks! See Question&Answers more detail:os...

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

0 votes

414 views

1 answer

sql - Performance of SUBSTR on CLOB

I have a PL/SQL procedure that does a lot of SUBSTRs on a VARCHAR2 parameter. I would like to remove the length ... ' (DBMS_LOB.SUBSTR)'); END; See Question&Answers more detail:os...

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

0 votes

379 views

1 answer

sql - Impact of defining VARCHAR2 column with greater length

What are the effects of defining a column with VARCHAR2(1000) instead of VARCHAR2(10) in Oracle, when ... /performance of tablespaces/indexes? See Question&Answers more detail:os...

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

0 votes

382 views

1 answer

sql - Inner join with count() on three tables

Simple and fast question, i have those tables: //table people | pe_id | pe_name | | 1 | Foo | | 2 | ... to combine those two queries in one? See Question&Answers more detail:os...

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

0 votes

484 views

1 answer

sql server - SQL Connection Pooling and Audit Login/Logout

When I profile my application using SQL Server Profiler, I am seeing lots of Audit Login and Audit Logout ... pooling. Thanks in advance! See Question&Answers more detail:os...

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

0 votes

275 views

1 answer

sql server - SQL Query Multiple Columns Using Distinct on One Column Only

I am trying to write a SQL query that selects multiple columns from a table with the distinct operator on one ... Results: 1 Citrus 4 Seed See Question&Answers more detail:os...

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

0 votes

333 views

1 answer

sql - rails scope to check if association does NOT exist

I am looking toward writing a scope that returns all records that do not have a particular association. foo.rb ... way to do the opposite. See Question&Answers more detail:os...

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

0 votes

318 views

1 answer

sql - Count of non-null columns in each row

I have a table that contains 4 columns and in the 5th column I want to store the count of how many non-null columns ... | NULL | NULL | NULL | 0 See Question&Answers more detail:os...

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

0 votes

262 views

1 answer

sql server - Code First Migrations and Stored Procedures

I have just created a database and done my first migration (just a simple table add). Now I want to ... /remove them using Management Studio? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags