Questions tagged [sql-server-2019-express]
36 questions
0
votes
0 answers
Error trying to access a remote database in SQL Server with C#
I am trying to access a database I have recently developed remotely from another computer but on the same network. However, I always get the same error when trying to connect the database to the system built from…
Francisco Javier Espinosa L
- 167
- 1
- 1
- 7
0
votes
1 answer
Login failed for user 'nostalgic_bohr'. .... Error Number:18456,State:1,Class:14
I am trying to connect and use CRUD operations on a ms sql server with sql server authentication which is run in a docker container (created from this docker image
mcr.microsoft.com/mssql/server:2019-latest).
My problem seems to be logging into the…
Deck
- 11
- 2
0
votes
2 answers
Find UserName in Different Table Using UserId
I have two tables. One is the userInfo table another is the income expenses table, This table has multiple columns. I want to summation these columns using GROUP BY and try to show TotalIncome, Totalexpenses and userName that it.
Here is the query:
…
Mizanur Rahaman
- 411
- 1
- 4
- 10
0
votes
1 answer
Couldn't run the SQL Server 2019 installation file on Windows 11
I am trying to install SQL Server 2019 for a non-production work on my personal laptop. I downloaded and tried running the SQL Server Express installer file but happened after the double click. I did the same Developer edition installer file as…
sagar sadhu
- 1
- 3
0
votes
1 answer
Delphi ADO can't find MSSQL 2019 server
I needed to update my old 2008 MSSQL to 2019 Express. (Both accessed locally on the same computer)
This works as far as I can tell since I can see my database in SQL Server Management Studio. So seems to me that is working. (The way I test is I also…
Tom
- 3,587
- 9
- 69
- 124
0
votes
0 answers
How to avoid displaying old data in DataGrid (populated using EntityFramework instance) when the project is rebuilt?
I am being displayed old data when I run the WPF app. I have created two dbcontexts on two different pages. When I rebuild the solution, I get the old data. I have also selected the value of "Copy to Output Directory" to "Copy if newer." It does not…
Bill Joeden
- 10
- 2
0
votes
2 answers
Date in where clause returning 0 rows
I am trying to get data as follows
WHERE DateCommande = '2018-09-05'
but it doesn't work on my computer.
SELECT *
FROM dbo.Commande;
Returns rows, including rows that show 2018-09-05 as the datetime value in a datetime column.
However, on SSMS…
LeCanardNoir
- 19
- 4
0
votes
0 answers
Why is my WHERE clause not working as intended?
I am running a query to apply a number depending on the WHERE clause which verifies information from different tables
UPDATE EstadoDoc
SET PuntajePrevio = 10
FROM Investigador i, Autores a, Documentos d, EstadoDoc e, Periodo p
WHERE i.IdInv =…
alex schobel
- 87
- 2
- 11
0
votes
0 answers
Verifing all FK in SQL Server 2019 database that exist in other tables
I have a table MyTable with these columns:
MyTableId: int
Results: varchar(200)
And I have another table called Users:
UserId: int
Username: varchar(200)
MyTableId: int
I am cleaning up MyTable and I have a bunch of results that are now saying…
cdub
- 24,555
- 57
- 174
- 303
0
votes
2 answers
Import data (.xls file) into SQL Server - I get this error
TITLE: SQL Server Import and Export Wizard
The operation could not be completed.
ADDITIONAL INFORMATION:
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)
0
votes
1 answer
Get rows of Last hour, Last 'x' minutes in SQL Server
Order ID
Picker ID
Time_Picked
1
111
2020-01-13 11:28:00
2
222
2020-01-13 11:40:00
3
333
2020-01-13 10:00:00
4
444
2020-01-13 9:00:00
5
555
2020-01-13 9:45:00
SELECT *
FROM mytable
WHERE Time_picked BETWEEN DATEADD(HOUR,…
Sai
- 71
- 7
0
votes
1 answer
Cannot start SQL server Agent on windows 10
I'm trying to start SQL server Agent on windows 10, I'm getting following error. - SQL server Agent have installed with SQL express - custom installation
Following things which I tried to resolve this issue with no luck. :(
Change Built in…
ISHIDA
- 4,700
- 2
- 16
- 30
0
votes
0 answers
The Collation specified by SQL Server is not supported. (Microsoft SQL Server 2019)
The Collation specified by SQL Server is not supported. (Microsoft SQL Server)
Could anyone help with this ?
Елдана Кеңес
- 1
- 2
0
votes
1 answer
.NET Core 3.1 application with SQL Server 2019 Express multiple databases support with main database for authentication
I'm building a web application with .NET Core 3.1 and Angular 9. I would like to know if it is possible to use the internal .NET Core authentication / authorization mechanism to connect to an "authorization" database and based on the credentials…
Tony
- 27
- 1
- 7
0
votes
0 answers
How to check every row/column in a table and log all the errors found in SQL Server?
I need help on how to code this in SQL Server 2019 Express.
I have a flat file that I BULK INSERT into a temporary table. What I wanted to do is on how to log every verification/invalid data on each row/column to another table which is the…
Ann
- 61
- 7