Recent questions tagged SQL

0 votes

458 views

1 answer

sql server - Firewall Port 1433 not opening

I am using MS Server 2008 with MSSQL 2008-R2 as database server. Each time for some work i have to login to ... . thanks in advance....... See Question&Answers more detail:os...

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

0 votes

314 views

1 answer

sql - Does Oracle roll back the transaction on an error?

This feels like a dumb question, but I see the following in the Oracle concepts guide on transaction management: ... will get rolled back? See Question&Answers more detail:os...

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

0 votes

270 views

1 answer

sql - How simultaneous queries are handled in a MySQL database?

I am using MySQL database and I would like to know if I make multiple (500 and more) queries simultaneously ... ? Sequentially or in parallel? See Question&Answers more detail:os...

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

0 votes

477 views

1 answer

sql server - xml-sql: update multiple nodes

I have the following problem. i have a xml file stored in a sql database. i should change all the VALUE ... instruction? thanx in advance diego See Question&Answers more detail:os...

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

0 votes

710 views

1 answer

sql - Oracle DB equivalent of on duplicate key update

I need to execute the following MySQL-query in Oracle: INSERT INTO users VALUES(1,10) ON DUPLICATE KEY UPDATE ... just don't understand it. See Question&Answers more detail:os...

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

0 votes

301 views

1 answer

sql - This SELECT query takes 180 seconds to finish

UPDATE: Just to mention it on a more visible place. When I changed IN for =, the query execution time went from ... so it shouldn't be so slow. See Question&Answers more detail:os...

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

0 votes

273 views

1 answer

sql - How to choose my primary key?

I found this reading material on choosing a primary key. Is there a guide / blog post on how to choose the primary ... , even if it's a string? See Question&Answers more detail:os...

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

0 votes

360 views

1 answer

sql - Finding all records without associated ones

I have a teams table and a players table and I'm wanting to find all teams that do not have players associated ... a Team and a Player model. See Question&Answers more detail:os...

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

0 votes

240 views

1 answer

sql server - What is wrong with Cursors?

SQL Server developers consider Cursors a bad practise , except under some circumstances. They believe that Cursors ... apply to both products? See Question&Answers more detail:os...

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

0 votes

408 views

1 answer

sql - Ignore certain columns when using BULK INSERT

I have a comma delimited text file with the structure field1 field2 field3 field4 1 2 3 4 I wrote the ... in the create table statement? See Question&Answers more detail:os...

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

0 votes

349 views

1 answer

sql - IIS connecting to LocalDB

Is there any way so IIS could connect to LocalDB without using the NT SERVICENETWORK SERVICE user account ... without changing permissions? See Question&Answers more detail:os...

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

0 votes

893 views

1 answer

sql - The argument 1 of the XML data type method "value" must be a string literal

How to change my T-SQL query so that this error doesn't occur: 'The argument 1 of the XML data type method " ... )')) from OtherTable WHERE ID=2 See Question&Answers more detail:os...

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

0 votes

508 views

1 answer

sql - Query validation using C#

I am looking for a query validator in C#, which allows me to parse the SQL text from a textbox and verify whether ... (MS SQL or DB2 queries). See Question&Answers more detail:os...

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

0 votes

285 views

1 answer

sql server - T-SQL 1=1 Performance Hit

For my SQL queries, I usually do the following for SELECT statements: SELECT ... FROM table t WHERE 1=1 AND t.[ ... ] = @param2 <-- changed ... See Question&Answers more detail:os...

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

0 votes

455 views

1 answer

sql - PostgreSQL nested INSERTs / WITHs for foreign key insertions

I'm using PostgreSQL 9.3, and I'm trying to write a SQL script to insert some data for unit tests, ... fiddle here which contains this example.) See Question&Answers more detail:os...

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

0 votes

363 views

1 answer

sql - Casting Scientific Notation (from varchar -> numeric) in a view

For reasons I can not help I have a varchar column with data like the following: 820.0E-12, 10.0E+00. I ... , it breaks/gives the wrong result. See Question&Answers more detail:os...

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

0 votes

389 views

1 answer

sql - isnull vs is null

I have noticed a number of queries at work and on SO are using limitations in the form: isnull(name,'') <> ... a legacy or a performance issue? See Question&Answers more detail:os...

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

0 votes

333 views

1 answer

sql - Can the "IN" operator use LIKE-wildcards (%) in Oracle?

I have searched this question, and found an answer in MySQL but this is one of those incidents where the ... Progress%') Thanks for any help See Question&Answers more detail:os...

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

0 votes

377 views

1 answer

sql - Deleting duplicates rows from redshift

I am trying to delete some duplicate data in my redshift table. Below is my query:- With duplicates As ... anybody faced this situation before? See Question&Answers more detail:os...

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

0 votes

259 views

1 answer

sql server - Filter by Dates in SQL

I have a column in my table for dates (DateTime) and I am trying to create a WHERE clause that says ... working with @RichardTheKiwi's options. See Question&Answers more detail:os...

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

0 votes

351 views

1 answer

sql server - SQL UPDATE TOP with ORDER BY?

I have a following query: UPDATE TOP (@MaxRecords) Messages SET status = 'P' OUTPUT inserted.* FROM Messages ... statement. Any other ideas? See Question&Answers more detail:os...

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

0 votes

299 views

1 answer

sql - Postgres trigger after insert accessing NEW

I have a pretty simple trigger: CREATE OR REPLACE FUNCTION f_log_datei() RETURNS TRIGGER AS $$ BEGIN INSERT INTO logs ( ... the same way I do. See Question&Answers more detail:os...

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

0 votes

494 views

1 answer

sql server - How to fix "Must declare the scalar variable" error when referencing table variable?

I can't figure out why (or maybe you just can't do this) I get the out of scope ... END CLOSE Companies_Cursor DEALLOCATE Companies_Cursor END See Question&Answers more detail:os...

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

0 votes

382 views

1 answer

sql - Why isn't MySQL using any of these possible keys?

I have the following query: SELECT t.id FROM account_transaction t JOIN transaction_code tc ON t.transaction_code_id = tc. ... Why is key NULL? See Question&Answers more detail:os...

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

0 votes

287 views

1 answer

sql server - sql like operator to get the numbers only

This is I think a simple problem but not getting the solution yet. I would like to get the valid numbers only from ... there a way to do this? See Question&Answers more detail:os...

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

0 votes

585 views

1 answer

sql - MYSQL Left Join how do I select NULL values?

This is a follow up question to my last question about table joins in MySQL I need to be able to select ... them results? Appreciate any help. See Question&Answers more detail:os...

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

0 votes

736 views

1 answer

sql server - Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)

I am creating a store procedure but while executing the procedure i am getting the particular error. Msg 217, Level ... details: end-- END` See Question&Answers more detail:os...

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

0 votes

341 views

1 answer

sql - Create date from day, month, year fields in MySQL

I am currently developing an application that displays documents and allows the members to search for these ... DEFAULT CHARSET=latin1; See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags