Recent questions tagged SQL

0 votes

675 views

1 answer

sql server - IsDate Function in SQL evaluates invalid dates as valid

I am running a SQL Statement against imported data from Excel Files. In this SQL I am checking if the users ... Smacking users' did not help. See Question&Answers more detail:os...

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

0 votes

328 views

1 answer

sql - How to get multiple rows into one line as a string?

I have two tables "one to many": Table1 ID Name 1 Abe 2 David 3 Orly Table2 ID email 1 [email protected] 1 ab@zz ... . How should this be solved? Thanks. See Question&Answers more detail:os...

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

0 votes

556 views

1 answer

sql - CTE to traverse back up a hierarchy?

I can find all the children of a given record in a hierarchical data model (see code below) but I'm ... ORDER BY HierarchyLevel, [Subject] See Question&Answers more detail:os...

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

0 votes

439 views

1 answer

sql - Mysql: Which to use when: drop table, truncate table, delete from table

List the differences between the following MySql commands. drop table tablename; truncate table tablename; delete from ... scenario for each. See Question&Answers more detail:os...

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

0 votes

448 views

1 answer

sql server - Connect to SQLServer running in a parallels VM

I'm running a Windows 7 VM via Parallels on OSX. There's an instance of SQL Server running on that VM. ... insights or helpful resources? TIA! See Question&Answers more detail:os...

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

0 votes

403 views

1 answer

sql server - Which lock hints should I use (T-SQL)?

I want to implement an atomic transaction like the following: BEGIN TRAN A SELECT id FROM Inventory WITH ... current transaction completes." See Question&Answers more detail:os...

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

0 votes

410 views

1 answer

sql - Oracle: how to get percent of total by a query?

I have the following query and its result is very unexpected to me: select stato, (count(1) *100) / sum(1 ... all rows. Should it be different ? See Question&Answers more detail:os...

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

0 votes

503 views

1 answer

sql - Java Date and Timestamp from instance of ZonedDateTime UTC

I have a java application in which I would like the time in UTC. Currently, the code uses a mix of java.util.Date ... Apr 06 10:46:33 CDT 2017 See Question&Answers more detail:os...

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

0 votes

658 views

1 answer

sql server - How to I find all tables that have foreign keys that reference particular table.column AND have values for those foreign keys?

I have a table whose primary key is referenced in several other tables as a foreign key. For example: CREATE ... values in the foreign key? See Question&Answers more detail:os...

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

0 votes

527 views

1 answer

sql server - SQL query to return only 1 record per group ID

I'm looking for a way to handle the following scenario. I have a database table that I need to return ... against a SQL Server 2005 database. See Question&Answers more detail:os...

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

0 votes

517 views

1 answer

sql - Are left outer joins associative?

It's easy to understand why left outer joins are not commutative, but I'm having some trouble understanding whether ... B left outer join C)? See Question&Answers more detail:os...

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

0 votes

432 views

1 answer

sql - Return only one row from the right-most table for every row in the left-most table

I have two tables. I want to join them in a way that only one record in the right table is returned for each record in the ... ----------------- See Question&Answers more detail:os...

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

0 votes

410 views

1 answer

sql - Concatenate/merge array values during grouping/aggregation

I have a table with the an array column type: title tags "ridealong";"{comedy,other}" "ridealong";"{comedy, ... =t1.title GROUP BY t1.title; See Question&Answers more detail:os...

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

0 votes

479 views

1 answer

sql server - How can I Schedule a Sql job in Microsoft Azure SQL database?

I have one SQL Agent maintenance job which checks the index fragmentation within a database and rebuilds indexes if ... Job in Azure Db? See Question&Answers more detail:os...

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

0 votes

384 views

1 answer

sql - Select Query by Pair of fields using an in clause

I have a table called players as follows: First_Id Second_Id Name 1 1 Durant 2 1 Kobe 1 2 Lebron 2 2 Dwight ... as illustrated. I'm using DB2. See Question&Answers more detail:os...

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

0 votes

528 views

1 answer

sql server - How to delete (localdb) database if the file is gone

If I run SQL Server Management Studio, and tell it to connect to (localdb)v11.0, it knows about every ... database files are gone? Bob See Question&Answers more detail:os...

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

0 votes

362 views

1 answer

sql server - Combination of 'LIKE' and 'IN' using t-sql

How can I do this kind of selection: SELECT * FROM Street WHERE StreetName LIKE IN ('% Main Street', 'foo ... these actually comes from a query. See Question&Answers more detail:os...

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

0 votes

362 views

1 answer

sql server - Counting no of rows returned by a select query

I need to count the no of rows which is returned by the following query. select m.Company_id from Monitor as m ... 7 Incorrect syntax near ')'. See Question&Answers more detail:os...

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

0 votes

532 views

1 answer

sql server - How to get number of rows inserted by a transaction

I have to manage a log where i have to see the number of rows that are inserted by a transaction. Is there any way of doing it dynamically ? See Question&Answers more detail:os...

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

0 votes

446 views

1 answer

sql server - How can I execute a set of .SQL files from within SSMS?

How could I execute a set of .SQL files (each does some data transformations) from within SQL Server Management ... .SQL files in batch? See Question&Answers more detail:os...

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

0 votes

472 views

1 answer

sql - unwrap postgresql array into rows

What is the fastest way to unwrap array into rows in PostgreSQL? For instance, We have: a - {1,2} {2,3,4} ... as s; $$ Is there any better way? See Question&Answers more detail:os...

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

0 votes

361 views

1 answer

sql - Simple check for SELECT query empty result

Can anyone point out how to check if a select query returns non empty result set? For example I have next query: ... if result set is not empty? See Question&Answers more detail:os...

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

0 votes

442 views

1 answer

sql - Does the order of columns matter in a group by clause?

If I have two columns, one with very high cardinality and one with very low cardinality (unique # of ... there situations where it matters? See Question&Answers more detail:os...

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

0 votes

290 views

1 answer

sql server - Handling multiple records in a MS SQL trigger

I am having to use triggers in MSSQL for the first time, well triggers in general. Having read around and tested this myself I ... = CONVERT(Date, i.[Date]) AND s.AdvertId = i.Ad...

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

0 votes

304 views

1 answer

sql - Oracle: Full text search with condition

I've created an Oracle Text index like the following: create index my_idx on my_table (text) indextype is ctxsys.context; ... an index on (A,B). See Question&Answers more detail:os...

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

0 votes

477 views

1 answer

sql server - Rollback transaction using transaction log

Would it be possible rollback transactions using Transactionlog file for a particular record? I am using SQL Server 2005. See Question&Answers more detail:os...

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

0 votes

413 views

1 answer

sql - Make all store images the base, small and thumbnail images in Magento?

I have a Magento store that has around 3,000 products. Almost all of these products have a single image ... isn't working? Thanks, Danny See Question&Answers more detail:os...

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

0 votes

390 views

1 answer

sql - Group data by the change of grouping column value in order

With the following data create table #ph (product int, [date] date, price int) insert into #ph select 1, ' ... the cleanest way to achieve this? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags