Recent questions tagged SQL

0 votes

671 views

1 answer

sql server - Combining datasets with EXCEPT versus checking on IS NULL in a LEFT JOIN

I'm currently working my way through the Microsoft SQL Server 2008 - Database Development (MCTS Exam 70-433) ... this question to be answered. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - Postgres: convert single row to multiple rows (unpivot)

I have a table: Table_Name: price_list ----------------------------------------- ... help with links to similar examples greatly appreciated. See Question&Answers more detail:os...

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

0 votes

805 views

1 answer

sql - performing datetime related operations in PHP

How do you actually perform datetime operations such as adding date, finding difference, find out how many days ... FROM all_days) < 6; See Question&Answers more detail:os...

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

0 votes

994 views

1 answer

sql - Delphi: Paradox DB Field Name Issue (Spaces in field name)

I have a paradox table from a legacy system I need to run a single query on. The field names have ... , standard Tquery object name query1. See Question&Answers more detail:os...

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

0 votes

854 views

1 answer

sql server - sql: BETWEEN v1 AND v2

Is there a difference in the order of v1 and v2 in a BETWEEN query on SQL Server? SELECT * FROM table WHERE col ... I guess it's the first case. See Question&Answers more detail:os...

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

0 votes

782 views

1 answer

sql - TSQL Comparing two Sets

When two sets are given s1 ={ a,b,c,d} s2={b,c,d,a} (i.e) TableA Item a b c d ... Output Elements in TableA and TableB contains identical sets See Question&Answers more detail:os...

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

0 votes

742 views

1 answer

sql - How do I work with high precision decimals in PHP

I am trying to create a database-driven website with PHP and with data stored in a PostgreSQL database, (accessed ... can be imprecise. Thanks! See Question&Answers more detail:os...

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

0 votes

695 views

1 answer

sql - MySQL: Name primary key in CREATE TABLE statement

How do I set the name of a primary key when creating a table? For example here I'm trying to create a ... will be something I have specified. See Question&Answers more detail:os...

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

0 votes

699 views

1 answer

sql server 2008 - SSRS report formatting a table to display data side by side

I am trying to achieve the following layout for my report based on one query. +----+-------+----+- ... side-by-side in Report Designer? Thanks, See Question&Answers more detail:os...

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

0 votes

686 views

1 answer

sql server - T-Sql appears to be evaluating "If" statement even when the condition is not true

I have a T-Sql script where part of this script checks to see if a certain column exists in the a table. If so, ... FALSE and I don't know why. See Question&Answers more detail:os...

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

0 votes

665 views

1 answer

sql server - automate a SQL query to run every month

I have a simple SQL query that updates some date fields in a record, on a SQL Express instance. I'd ... Express using the Management Studio? See Question&Answers more detail:os...

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

0 votes

699 views

1 answer

sql server - Get the minimum value between several columns

I'm using SQL Server 2008; Suppose I have a table 'X' with columns 'Date1', 'Date2', 'Dateblah', all of type ... pain if I have 6 ou 7 columns. See Question&Answers more detail:os...

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

0 votes

770 views

1 answer

sql - InnoDB mySQL unable to set "ON DELETE SET DEFAULT'. How to set?

I am trying to create a table named EMPLOYEE. When I use the following statements without "ON DELETE SET DEFAULT" ... and Thanks in advance :) See Question&Answers more detail:os...

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

0 votes

926 views

1 answer

sql - Rails ActiveRecord where or clause

I'm looking to write an ActiveRecord query and this is what I have below. Unfortunately you can't ... .category_id" => category_ids) See Question&Answers more detail:os...

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

0 votes

993 views

1 answer

sql server - Dynamic SQL error converting nvarchar to int

I have created a procedure in dynamic SQL which has a select statement and the code looks like: ALTER PROCEDURE ... Where am I doing wrong? See Question&Answers more detail:os...

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

0 votes

852 views

1 answer

sql server - Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics

I have checked over the whole web and couldn't find a solution that seems to work for me.. I have recreated my ... can do..please help me ;_; See Question&Answers more detail:os...

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

0 votes

760 views

1 answer

sql update - Updating a field in all records in elasticsearch

I'm new to ElasticSearch, so this is probably something quite trivial, but I haven't figured out anything better ... a pool of valid values). See Question&Answers more detail:os...

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

0 votes

701 views

1 answer

sql - Renaming a column without breaking the scripts and stored procedures

I want to modify a column name to new name present in a table but here problem i want to manually modify ... s.? without opening each script? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql server - How do you escape double quotes inside a SQL fulltext 'contains' function?

How do you escape a double quote character inside a MS SQL 'contains' function? SELECT decision FROM table ... query for example purposes. See Question&Answers more detail:os...

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

0 votes

782 views

1 answer

sql - Query jsonb column containing array of JSON objects

I use PostgreSQL 9.5 and Rails 5. I want to query the jsonb column shown below that holds an ... index_segments_on_payload", using: :gin end See Question&Answers more detail:os...

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

0 votes

762 views

1 answer

sql - Concatenate records and GROUP BY in Access

I have a table like this: title part desc Blah This 1 This begins the Blah This 2 example table. Some ... while the query is already open? 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 - Invalid column name error in WHERE clause, column selected with CASE

I have a (rather complicated) SQL statement where I select data from lots of different tables, and to cope with ... ? What should I do instead? See Question&Answers more detail:os...

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

0 votes

635 views

1 answer

sql server - SQL query like GROUP BY with OR condition

I'll try to describe the real situation. In our company we have a reservation system with a table, let's call ... and sorry for my wrong start. 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 - Ignore XML namespace in T-SQL

How do I remove/ignore the XML namespace in an xml file when querying the data with T-SQL? I'm loading an ... my query to handle the namespace? See Question&Answers more detail:os...

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

0 votes

807 views

1 answer

sql - SQLite IF Exists Clause

How to write IF EXISTS as shown in below query in SQLite? I read somewhere that IF clause doesn't exist in ... as uname else select 0 as uname See Question&Answers more detail:os...

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

0 votes

777 views

1 answer

sql server - Sql Like to RegEx

Is there a good way to convert Regular Expression into LIKE inside a Function (MSSQL)? The sproc does not get more ... is a part of [Table] See Question&Answers more detail:os...

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

0 votes

966 views

1 answer

sql - How to use GROUP BY in firebird

The structure of T_TABLE2 is ID INT TBL1_ID INT TESTER VARCHAR LOT_ID VARCHAR GRP VARCHAR SITE_NUM INT TEST_NUM VARCHAR ... GROUP BY clause). See Question&Answers more detail:os...

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

0 votes

719 views

1 answer

sql - Java: Calling a stored procedure in an oracle database

EDIT: While some of the answers in this question may help others with different problems, the solution was ... help would be appreciated! See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags