Recent questions tagged sql

0 votes

287 views

1 answer

sql server - Is there a way to simplify a NULL compare of 2 values

This is my simplified statement SELECT ... FROM tab1 AS i FULL OUTER JOIN tab2 AS d ON i.[Id]=d.[Id] ... . My statement works for every type. See Question&Answers more detail:os...

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

0 votes

269 views

1 answer

sql - SELECT * FROM Linked MySQL server

I have a SQL Server 2012.(120.120.55.15) Today I linked MySQL server(120.120.55.30) to my SQLServer and ... done to use my linked MySQL server? See Question&Answers more detail:os...

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

0 votes

330 views

1 answer

sql - How do you create a parameterized query in MS Access 2003 and use other queries/forms to fill the parameters and obtain a resultset

I'd like to be able to create a parameterized query in MS Access 2003 and feed the values of certain form elements ... to use VBA, that's fine. See Question&Answers more detail:os...

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

0 votes

423 views

1 answer

sql server 2008 - Recursive Child/Parent queries in T/SQL

I am using T/SQL in Microsoft SQL Server 2008 I have a table CREATE TABLE [TestTable]( [CHILD] [int] NOT NULL ... how to solve this? Thank you! See Question&Answers more detail:os...

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

0 votes

258 views

1 answer

sql - Why postgres returns unordered data in select query, after updation of row?

I am bit confused over default ordering of the rows returned by postgres. postgres=# select * from check_user; id ... uses ? Thanks in advance. See Question&Answers more detail:os...

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

0 votes

282 views

1 answer

sql - Is there a way to select nth column in a SELECT clause from a table/view

I've this GIGANTIC view with several hundred columns and I need to select 114th column something like: SELECT ... my further debugging. Cheers! See Question&Answers more detail:os...

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

0 votes

256 views

1 answer

sql - Is there a way to select nth column in a SELECT clause from a table/view

I've this GIGANTIC view with several hundred columns and I need to select 114th column something like: SELECT ... my further debugging. Cheers! See Question&Answers more detail:os...

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

0 votes

394 views

1 answer

sql - How to bulk insert only new rows in PostreSQL

I have list of products (3 million items) without IDs - only titles. But I don't know which titles already ... values, add columns etc.). See Question&Answers more detail:os...

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

0 votes

297 views

1 answer

sql - Prepared Statements in VB.NET

I am new to prepared statements in vb.net and Microsoft SQL Server 2008. I can't really find any good ... a resource that might be useful? See Question&Answers more detail:os...

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

0 votes

241 views

1 answer

sql - How to use a ring data structure in window functions

I have data that is arranged in a ring structure (or circular buffer), that is it can be expressed as sequences that ... , 7) order by random(); See Question&Answers more detail:os...

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

0 votes

461 views

1 answer

sql - check if a column contains ALL the values of another column - Mysql

Let's suppose I have a table T1 with people IDs and other stuff IDs, as the following Table: T1 personID | ... are included in T2.stuffID). See Question&Answers more detail:os...

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

0 votes

363 views

1 answer

sql - Does MS access(2003) have anything comparable to Stored procedure. I want to run a complex query in MS acceess

I have a table, call it TBL. It has two columns,call them A and B. Now in the query I require one ... through SQL to run this type of query See Question&Answers more detail:os...

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

0 votes

344 views

1 answer

sql - Fetch records that are non zero after the decimal point in PostgreSQL

I have a table with an amount field of type Numeric. It contains different amount values. For example 5.00 7.13 8.86 ... 8.86 How can I do it? See Question&Answers more detail:os...

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

0 votes

562 views

1 answer

sql - How to call Oracle MD5 hash function?

I have below code. I am using Oracle 11g. SELECT DBMS_OBFUSCATION_TOOLKIT.md5 (input => UTL_RAW.cast_to_raw( ... this code in sqldeveloper? See Question&Answers more detail:os...

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

0 votes

344 views

1 answer

sql - MySQL - Complexity of: SELECT COUNT(*) FROM MyTable;

What is the complexity of this MySQL query SELECT COUNT(*) FROM MyTable; Is the count of number of entries in a ... complexity should be O(1). See Question&Answers more detail:os...

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

0 votes

328 views

1 answer

sql server - "If not exists" fails on SQL CE

I've got an unexpected problem. I'm making a script to update the schema on a SQL CE database. This won't ... is causing so much difficulty :( See Question&Answers more detail:os...

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

0 votes

256 views

1 answer

sql - Is there a quick way to check if ANY column is NULL?

I have a table with around 20 columns. Aside from typing out: Where column1 is null OR column2 is null OR ... if so, return that record? See Question&Answers more detail:os...

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

0 votes

325 views

1 answer

sql swap primary key values

is it possible to swap primary key values between two datasets? If so, how would one do that? See Question&Answers more detail:os...

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

0 votes

454 views

1 answer

sql - What is the problem with foreign key cascade multiple paths and cycles?

In SQL Server 2005 I just struck the infamous error message: Introducing FOREIGN KEY constraint XXX on table YYY may ... ? Where is the problem? See Question&Answers more detail:os...

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

0 votes

499 views

1 answer

sql server - Cannot create a row of size 8937 which is greater than the allowable maximum of 8060

We are getting this error on a table in our database: Cannot create a row of size 8937 which is greater than the ... I will not go into here. See Question&Answers more detail:os...

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

0 votes

251 views

1 answer

sql - IN vs OR of Oracle, which faster?

I'm developing an application which processes many data in Oracle database. In some case, I have to get many ... improve the speed of query? See Question&Answers more detail:os...

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

0 votes

339 views

1 answer

sql server - how to show column value only one time if it is repeated and blank until different value comes in sql

we have a simple table containing category and budget type column as show in the picture above I want to show ... I use select * query. See Question&Answers more detail:os...

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

0 votes

366 views

1 answer

sql - How to find LEFT OUTER JOIN or RIGHT OUTER JOIN with ORACLE JOIN (+)

I am confused with finding left outer join and right outer join properly with Oracle join (+) sign. Check ... join properly with an example? See Question&Answers more detail:os...

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

0 votes

601 views

1 answer

sql - Split string by space and character as delimiter in Oracle with regexp_substr

I'm trying to split a string with regexp_subtr, but i can't make it work. So, first, i have this ... Help will be much appreciated! Thanks See Question&Answers more detail:os...

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

0 votes

234 views

1 answer

sql - How to create an index for elements of an array in PostgreSQL?

With this schema: create table object ( obj_id serial primary key, name varchar(80) not null unique, ... char, limiting its usefulness. See Question&Answers more detail:os...

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

0 votes

249 views

1 answer

sql - Split column to multiple rows

I have table with a column that contains multiple values separated by comma (,) and would like to split it so I get ... Site,',',1,seq) > 0 See Question&Answers more detail:os...

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

0 votes

247 views

1 answer

sql - Is it possible to pass table name as a parameter in Oracle?

I want to create a stored procedure like this: PROCEDURE P_CUSTOMER_UPDATE ( pADSLTable IN Table, pAccountname IN ... Thank you very much. See Question&Answers more detail:os...

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

0 votes

227 views

1 answer

sql - Single or multiple databases

SQL Server 2008 database design problem. I'm defining the architecture for a service where site users would manage a ... ? Thanks for your help. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags