Recent questions tagged SQL

0 votes

444 views

1 answer

How do I use DB2's Explain function? -- both to run it, and to use it to optimize queries. Is there a ... access." Don't you love bureaucracy? See Question&Answers more detail:os...

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

0 votes

344 views

1 answer

sql server - How can I pull a list of ID's from a SQL table as a comma-separated values string?

I have to pull a list of integer IDs from a table using only records that match some criteria. For example: ... query this way. Any ideas? See Question&Answers more detail:os...

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

0 votes

401 views

1 answer

sql - How to get all article pages under a Wikipedia Category and its sub-categories?

I want to get all the articles names under a category and its sub-categories. Options I'm aware of: Using ... in XML. Please share your thoughts See Question&Answers more detail:os...

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

0 votes

492 views

1 answer

sql - Truncate multiple tables in one MySQL statement

Is there a possibility to truncate with one SQL statement, multiple tables? Like this: truncate ... , #Dates_temp; Regards See Question&Answers more detail:os...

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

0 votes

387 views

1 answer

sql - MySQL Wildcards * and %

What is the difference between % and * wildcards in MySQL? In a query like so : "SELECT * FROM $table WHERE ... ('$string*' IN BOOLEAN MODE)" See Question&Answers more detail:os...

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

0 votes

395 views

1 answer

sql - JOIN (SELECT ... ) ue ON 1=1?

I am reading an SQL query in Redshift and can't understand the last part: ... LEFT JOIN (SELECT MIN(modified) AS ... What does ON 1=1 mean here? See Question&Answers more detail:os...

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

0 votes

375 views

1 answer

sql server - Best way to catch sql unique constraint violations in c# during inserts

I have a loop in c# that inserts into a table. pretty basic stuff. Is there something insdie the exception ... as a more permanent solution. See Question&Answers more detail:os...

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

0 votes

542 views

1 answer

sql searching multiple words in a string

What is the most efficient and elegant SQL query looking for a string containing the words "David", "Moses" and " ... named T and the column C. See Question&Answers more detail:os...

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

0 votes

290 views

1 answer

sql - How to select columns from a table which have non null values?

I have a table containing hundreds of columns many of which are null, and I would like have my select statement so ... value. Can this be done? See Question&Answers more detail:os...

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

0 votes

314 views

1 answer

sql - update statement using nested query

I have a table: mytable: id userID logDate lastLogDate For every row in that table, I want to update the ... the update statement for that? See Question&Answers more detail:os...

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

0 votes

331 views

1 answer

sql - How many tables can be created in a mysql database?

How many tables can be created in a mysql database ? And how many columns can be created in a mysql table ? ... be inserted into a mysql table ? See Question&Answers more detail:os...

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

0 votes

366 views

1 answer

sql server - How to rollback a transaction in TSQL when string data is truncated?

Currently I have a large import process that I'm trying to wrap inside a transaction so if anything breaks - i ... != 0 BEGIN ROLLBACK END See Question&Answers more detail:os...

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

0 votes

327 views

1 answer

sql - How to insert new row to database with AUTO_INCREMENT column without specifying column names?

I have a table with the following columns: id - INT UNSIGNED AUTO_INCREMENT name - VARCHAR(20) group - ... is no AUTO_INCREMENT column ? See Question&Answers more detail:os...

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

0 votes

355 views

1 answer

sql - Extracting the total number of seconds from an interval data-type

When subtracting timestamps the return value is an interval data-type. Is there an elegant way to convert this value into ... in SQL or PL/SQL? See Question&Answers more detail:os...

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

0 votes

395 views

1 answer

sql server - Joining to MAX date record in group

Job -------- Id Description JobStatus ---------- Id JobId StatusTypeId Date How do I get the current ... which exactly does what I need). See Question&Answers more detail:os...

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

0 votes

374 views

1 answer

sql server - database attached is read only

I used the following the script to attach a database. But the database created is read only. What modifications should ... N'sa', @map=false GO See Question&Answers more detail:os...

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

0 votes

281 views

1 answer

sql - My Select SUM query returns null. It should return 0

I'm trying to sum up Customer balances using the following query: select sum(balance) from mytable where customer = ' ... 0. What's the problem? See Question&Answers more detail:os...

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

0 votes

250 views

1 answer

sql server - Using a conditional UPDATE statement in SQL

I would like to have an UPDATE statement like this: SELECT * FROM Employee WHERE age = CASE WHEN (age < ... a suitable way around this problem. See Question&Answers more detail:os...

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

0 votes

920 views

1 answer

sql server - Node.js MSSQL tedius ConnectionError: Failed to connect to localhost:1433 - connect ECONNREFUSED

I am trying to connect to MSSQL 2012 using NodeJS with the mssql connection interface. When attempting to connect I get ... on how to fix this? See Question&Answers more detail:os...

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

0 votes

505 views

1 answer

sql - Arithmetic overflow error converting numeric to data type numeric

I keep getting this error message everytime I run this query: Msg 8115, Level 16, State 8, Line 33 ... DROP TABLE #temp DROP TABLE ##temp See Question&Answers more detail:os...

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

0 votes

387 views

1 answer

sql server - IndexOf function in T-SQL

Given an email address column, I need to find the position of the @ sign for substringing. What is the indexof function, ... ('c'); // yields 2 See Question&Answers more detail:os...

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

0 votes

434 views

1 answer

sql - Get the nearest longitude and latitude from MSSQL database table?

Ok I have searched SO and Google but haven't really found a definitive answer so throwing it out there for the ... up with a better solution? See Question&Answers more detail:os...

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

0 votes

285 views

1 answer

sql server 2005 - ASP.NET-MVC (IIS6) Error on high traffic: Specified cast is not valid

I just launched my tiny webapp on my humble dedicated server (Win2003)... running ASP.NET MVC, ... step, Boolean& completedSynchronously) See Question&Answers more detail:os...

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

0 votes

356 views

1 answer

sql - Trigger to prevent Insertion for duplicate data of two columns

I am working on SQL Server 2008R2, I am having the following Table ID Name date 1 XYZ 2010 2 ABC 2011 3 ... me how should i write this trigger. See Question&Answers more detail:os...

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

0 votes

570 views

1 answer

sql - Retrieve id of record just inserted into a Java DB (Derby) database

I am connecting to a Java DB database with JDBC and want to retrieve the id (which is on auto increment) of ... is the equivalent for Java DB? See Question&Answers more detail:os...

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

0 votes

782 views

1 answer

sql - Stratified random sampling with BigQuery?

How can I do stratified sampling on BigQuery? For example, we want a 10% proportionate stratified sample using the ... in some of our tables. See Question&Answers more detail:os...

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

0 votes

286 views

1 answer

sql - Best-performance query for "select max in group"?

I have a simple table comments (id INT, revision INT, comment VARCHAR(140)) with some content like this: ... better queries to accomplish this? See Question&Answers more detail:os...

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

0 votes

327 views

1 answer

sql server - Using SQL LocalDB in a Windows Service

I have a very small test application in which I'm trying to install a Windows Service and create a LocalDB ... SQL Server 2014 Express LocalDB. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags