Recent questions tagged SQL

0 votes

477 views

1 answer

sql - SELECT FOR XML AUTO and return datatypes

During playing with sys.dm_exec_describe_first_result_set I get to this point: CREATE TABLE #tab(col INT, x XML ... normal/temp table? See Question&Answers more detail:os...

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

0 votes

819 views

1 answer

sql - ORA-01219: database not open: queries allowed on fixed tables/views only

I Am using oracle 11g and SQL developer tool. When i tried to retrieve rows from db i am getting error message ... help me to make it working. See Question&Answers more detail:os...

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

0 votes

481 views

1 answer

sql - Detect duplicate items in recursive CTE

I have a set of dependencies stored in my database. I'm looking to find all the objects that depend on the ... huge waste of time and resource. See Question&Answers more detail:os...

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

0 votes

634 views

1 answer

sql server - MySQL INSERT with OUTPUT like MSSQL

I am pretty sure MySQL does not have the INSERT INTO table OUTPUT [column value] that MSSQL does - http://msdn ... UID prior to insert?) Thanks See Question&Answers more detail:os...

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

0 votes

514 views

1 answer

sql - Performance value of COMB guids

Jimmy Nilsson discusses his COMB guid concept here. This concept is popular in NHibernate, among other circles, ... gain appears non-existent. See Question&Answers more detail:os...

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

0 votes

501 views

1 answer

sql - Using a SELECT statement within a WHERE clause

SELECT * FROM ScoresTable WHERE Score = (SELECT MAX(Score) FROM ScoresTable AS st WHERE st.Date = ScoresTable.Date) Is ... and Score (e.g. name) See Question&Answers more detail:os...

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

0 votes

579 views

1 answer

sql - how to assign cte value to variable

;with CTEima(PersonId,IsEmployeeActive) as (select count(*) from custom.viwSSAppsEmpMasterExtended vem where vem. ... CTE into variable See Question&Answers more detail:os...

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

0 votes

502 views

1 answer

sql - Why can't I GROUP BY 1 when it's OK to ORDER BY 1?

Why are column ordinals legal for ORDER BY but not for GROUP BY? That is, can anyone tell me why this ... about an overall answer nonetheless. See Question&Answers more detail:os...

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

0 votes

506 views

1 answer

sql server - How do I call a stored procedure with arguments using sqlcmd.exe?

I need to call a stored procedure and pass arguments in from Powershell. I think the best option is to use ... the stored proc using this tool. See Question&Answers more detail:os...

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

0 votes

409 views

1 answer

sql - How Do I Deep Copy a Set of Data, and Change FK References to Point to All the Copies?

Suppose I have Table A and Table B. Table B references Table A. I want to deep copy a set of rows ... with no repercussions. Thanks, Tedderz See Question&Answers more detail:os...

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

0 votes

503 views

1 answer

sql - MYSQL ERROR 1248 (42000): Every derived table must have its own alias

I cant for the life of me figure out why this is erroring SELECT * FROM SELECT c.city_id, p.prop_ynow_id, p. ... limit 46 as a limit 0,50 See Question&Answers more detail:os...

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

0 votes

488 views

1 answer

sql - MySQL - Get a counter for each duplicate value

I have a table with two columns. +------+------+ | data | num ?| +------+------+ ... besides a mySQL query? UPDATE: extended question here See Question&Answers more detail:os...

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

0 votes

674 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

562 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

621 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

579 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

552 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

512 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

487 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

654 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

652 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

492 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

583 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

672 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

657 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

487 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

624 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

502 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)

Categories

Just Browsing Browsing

Most popular tags