336,780 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
1
vote
2
answers
98
views
Multiple SUM issue with EF SQL
I'm trying to use Linq to generate a SQL command like this
return await query.GroupBy(x => new
{
Id = x.xId,
...
0
votes
0
answers
84
views
What determines the physical order of rows in a SQL Server table variable? [duplicate]
Context: I am writing code to mirror subset of rows from a remote Azure SQL database. Each invoice is captured in several tables (invoice headers, invoice lines, ledger entries), and each of the data ...
0
votes
0
answers
53
views
Container Port Mapping Issue [closed]
I am encountering a port mapping issue when running SQL Server 2025 container with Docker. After the container starts, the port mapping displays incorrectly, preventing me from connecting to the SQL ...
-2
votes
0
answers
50
views
SQL Server 2012 setup fails with "Error while enabling Windows feature: MicrosoftWindowsPowerShellV2, Error Code : -2146498548" [closed]
I’m trying to install Microsoft SQL Server 2012 on my Windows machine using the installer
SQLEXPRADV_x64_ENU.exe. I’m using Windows 11 Home.
Error while enabling Windows feature : ...
3
votes
1
answer
63
views
Set SQL Server LoginTimeout in Laravel
I've encountered a problem in my Laravel 12 project. I usually save my data in a remote SQL Server database, but I have to consider the case of a db server malfunction. I have a backup local ...
-4
votes
0
answers
32
views
SQL Server on Linux: Cannot Create Linked Server to SAP HANA - "Only SQL Server provider allowed" Error [duplicate]
Environment:
SQL Server 2019/2022 on Linux (Ubuntu/RHEL)
SAP HANA Database
Previously working setup: SQL Server on Windows with Linked Server to HANA
Problem:
We successfully deployed SQL Server on ...
0
votes
0
answers
42
views
SSIS failing to connect to SQL Server clustered instance [closed]
We have a SSIS package on file system which was working well with a SQL Server agent job, until we moved SQL Server to a clustered instance. Now it looks like Integration Services, which are running ...
0
votes
0
answers
21
views
What is Microsoft SQL Server doing when I manually reduce the file size in Database Properties > Files? [migrated]
In Microsoft SQL Server I can go into Database Properties > Files and change the Size of a file to a lower number. If there's Space Available, it will actually reduce the file's size, and never ...
0
votes
0
answers
48
views
How to get rid of $ShardName when using sp_execute_remote?
When using the sp_execute_remote to call the remote SQL command, the call adds the column $ShardName to the result data set.
Is there any way to suppress returning that extra column? Two reasons...
...
1
vote
0
answers
46
views
SQL Server connection authentication in Azure DevOps pipeline for .NET seeding data .sln
I have a .NET application that seeds data to an Azure SQL database after deployment via Azure DevOps pipelines.
I'm struggling with authentication when using a connection string in Azure DevOps ...
0
votes
1
answer
111
views
SQL Query to select a string after an extension [duplicate]
Values:
1.zzz- Pipo
test.zzz-Done
blabla2.zzz-zip3
My question is, how can I get everything after .zzz- so the select statement from the value above will return:
Pipo
Done
zip3
3
votes
2
answers
101
views
Error when accessing data, EF Core seems to create its own column
I have a project that has uses a database-first approach. I have used db-scaffold to create the models and have also created 'custom' models to contain extra info and code.
I have a model class ...
1
vote
1
answer
90
views
Can C++ ADODB Connections to a SQL Server AG Specify Application Intent Read Only?
We have an SQL AG with read only routing correctly configured and confirmed working via sqlcmd -K readonly --> select @@servername confirms we are directed to a readable replica.
When attempting ...
4
votes
2
answers
176
views
How to perform a time-sequenced (temporal) LEFT OUTER JOIN
TL;DR In the book Developing Time-Oriented Database Applications in SQL by Richard T. Snodgrass, section 6.3.1 he demonstrates how to perform a sequenced inner join on a transaction-time state table, ...
0
votes
2
answers
91
views
How to update by the other GROUPed table values effectively?
I have the tables Invoices (with No_ key) and the related InvoiceLines (with [Document No_] key that bounds to their invoices). The subset of invoice numbers is inserted into the table variable (no ...