Recent questions tagged sql

0 votes

301 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

337 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

430 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

506 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

326 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

289 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

526 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

464 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

324 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

375 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

509 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

231 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

391 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

280 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

585 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

282 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

504 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

258 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

367 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

347 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

404 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

366 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

375 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

478 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

267 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

323 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

312 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

252 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