Recent questions tagged SQL

0 votes

502 views

1 answer

sql server - Python multiprocessing and database access with pyodbc "is not safe"?

The Problem: I am getting the following traceback and don't understand what it means or how to fix it: ... child process is fully created. See Question&Answers more detail:os...

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

0 votes

487 views

1 answer

sql server - ANSI SQL version of SELECT TOP 1

Is there an ANSI SQL compliant version of SQL SERVER's SELECT TOP n? See Question&Answers more detail:os...

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

0 votes

518 views

1 answer

sql - Create trigger prevent insert

I'm trying to execute the following trigger: create trigger t23 on studies after insert, update, delete as begin ... me in the right direction? See Question&Answers more detail:os...

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

0 votes

593 views

1 answer

sql server - Convert SQL geography to C#

What is the C# equivalent of this geospatial T-SQL code? DECLARE @g geography; DECLARE @h geography; SET @g ... to achieve equivalent C# code. See Question&Answers more detail:os...

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

0 votes

422 views

1 answer

sql server 2008 - Scripting setup of database mail

I've used the SQL Server 2008 GUI to set up database mail profiles & accounts on my test server, and I'd ... to generate a script to do this? See Question&Answers more detail:os...

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

0 votes

499 views

1 answer

sql server - Bit-flipping operations in T-SQL

I have a bitmasked int field in my database. Usually I manage it through C# code, but now I need to flip a bit ... 's missing in T-SQL, right? See Question&Answers more detail:os...

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

0 votes

503 views

1 answer

sql server 2008 r2 - Referencing a calculated column in the where clause SQL

This line of code is a snippet from my select statement. frdFreedays - DateDiff(dd,conReceiptToStock,GetDate() ... this Freedays <= @intFreeDays See Question&Answers more detail:os...

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

0 votes

887 views

1 answer

sql - native insert query in hibernate + spring data

I try to add the following code to a spring data jpa repository: @Query("insert into commit_activity_link (commit_id, ... ] Where am I wrong? See Question&Answers more detail:os...

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

0 votes

484 views

1 answer

sql - How do I iterate through the values of a row from a result set in java?

The result set I'm speaking of this: http://docs.oracle.com/javase/1.4.2/docs/api/java/sql/ResultSet.html ... is a variable, not a literal. See Question&Answers more detail:os...

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

0 votes

536 views

1 answer

sql server - Is there anyway to reset the identity of a Table Variable?

Say I have a table variable: DECLARE @MyTableVar TABLE (ID INT IDENTITY(1,1), SomeData NVARCHAR(300 ... | |___________|_________________| See Question&Answers more detail:os...

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

0 votes

508 views

1 answer

sql server - Maximum Connection Pool Size

I came across below text while reading about Database Connection pool properties: The maximum pool size property ... Oracle/SQL Server?) See Question&Answers more detail:os...

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

0 votes

676 views

1 answer

sql server - Invoke-SqlCmd doesn't return long string?

For the following code $sql = "select ..... for xml path('row')" # returns a long xml file $x = ... sure the full long string is returned? See Question&Answers more detail:os...

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

0 votes

609 views

1 answer

sql server - Remove dots and commas from column values

I am using SQL Server 2008 I migrated some data from MySql; the migration of data was successful but some ... these characters from my data? See Question&Answers more detail:os...

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

0 votes

495 views

1 answer

sql server - No fields for dynamic SQL stored procedure in SSRS with SET FMTONLY

I have the following SP which works correctly when ran on its own: USE [Orders] GO SET FMTONLY OFF; CREATE ... ? How can I resolve that? See Question&Answers more detail:os...

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

0 votes

547 views

1 answer

sql - JSON without array wrapper on lower levels

All I try to get is a simple SQL statement to build: {"status":{"code":404,"message":"Not found"},"otherthing" ... , sure, but I can not for-see See Question&Answers more detail:os...

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

0 votes

487 views

1 answer

sql - Any performance impact in Oracle for using LIKE 'string' vs = 'string'?

This SELECT * FROM SOME_TABLE WHERE SOME_FIELD LIKE '%some_value%'; is slower than this SELECT * FROM SOME_TABLE WHERE ... ever use "=" ? See Question&Answers more detail:os...

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

0 votes

524 views

1 answer

sql server - Using temp table with exec @sql in stored procedure

I have a stored procedure and part of them as below: @DRange is a incoming varchar value declare @sql varchar(max ... did I do something wrong? See Question&Answers more detail:os...

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

0 votes

575 views

1 answer

sql - Get the number of affected rows in a MySQL update statement?

I have stored procedure in MySQL, something like the below: create procedure SP_Test (input1 varchar(20)) begin ... changed by this update? See Question&Answers more detail:os...

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

0 votes

538 views

1 answer

sql - Do I need to call rollback if I never commit?

I am connecting to a SQL Server using no autocommit. If everything is successful, I call commit. Otherwise, ... explicitly commit or rollback. See Question&Answers more detail:os...

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

0 votes

870 views

1 answer

sql - Does SQLite support SCOPE_IDENTITY?

I'm trying to perform a simple INSERT and return the identity (auto-incrementing primary key). I've tried ... "thread-safe") alternatives? See Question&Answers more detail:os...

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

0 votes

498 views

1 answer

sql server - get new SQL record ID

How can I get back the autogenerated ID for a new record I just inserted? (Using ASP classic and MSSQL 2005) See Question&Answers more detail:os...

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

0 votes

499 views

1 answer

sql server - How to add more OR searches with CONTAINS Brings Query to Crawl?

I have a simple query that relies on two full-text indexed tables, but it runs extremely slow when I have the ... '"*fa*"') Execution Plan: See Question&Answers more detail:os...

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

0 votes

720 views

1 answer

sql - UNNEST function in MYSQL like POSTGRESQL

Is there a function like "unnest" from POSTGRESQL on MYSQL? Query (PSQL): select unnest('{1,2,3,4}'::int[]) ... _____| 3 | _____| 4 | _____| See Question&Answers more detail:os...

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

0 votes

469 views

1 answer

sql - SQLite3 Simulate RIGHT OUTER JOIN with LEFT JOINs and UNION

I have the following select statement where I need to sum each task from table tbTasks and group them by projectId ... way to achieve my goal? See Question&Answers more detail:os...

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

0 votes

653 views

1 answer

sql - MySql count() to return 0 if no records found

I have a set of posts on monthly basis. Now i need an array which contains total records of posts posted in each month. I ... ---------------+ See Question&Answers more detail:os...

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

0 votes

529 views

1 answer

sql - Return id if a row exists, INSERT otherwise

I'm writing a function in node.js to query a PostgreSQL table. If the row exists, I want to return the id column ... 't seem to get it to work. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - Does Liquibase support dry run?

We have couple of data schemas and we investigate the migration to Liquibase. (One of data schemas is already ... our schemas. Please help. See Question&Answers more detail:os...

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

0 votes

611 views

1 answer

sql server - Serilog.Sinks.MSSqlServer not filling custom columns

I've looked around, but I could not find a working solution, and since all examples look alike I assume it must ... 'ernst' order by id desc; See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags