Questions tagged [sql-server]
Microsoft SQL Server is a relational database management system (RDBMS). Use this tag for all Microsoft SQL Server editions including Compact, Express, Azure, Fast-track, APS (formerly PDW) and Azure SQL DW. Do not use this tag for other types of DBMS (MySQL, PostgreSQL, Oracle, etc.). Do not use this tag for issues on software and mobile development, unless it is directly related to the database.
sql-server
335,604
questions
0
votes
0
answers
4
views
Is it possible to get md5 of the entire table in SQL Server? E.g., by hashbytes
We want to get the md5 checksum of the entire table to verify the consistency of data, e.g. using the hashbytes() function of SQL Server.
As an intermediate step in the proof of concept, we figured ...
- 1
-2
votes
1
answer
15
views
Showing byte representation of NVARCHAR [duplicate]
In SQL Server, how can I show a byte representation of data in an NVARCHAR column?
e.g.
DECLARE @Example NVARCHAR(10) = 'Hello';
SELECT CAST(@Example AS ???)
# should produce something like '...
- 3,176
-2
votes
0
answers
19
views
Custom SQL Server datediff function with same logic as databricks [duplicate]
So apparently datediff on Databricks has different behavior compared to SQL Server.
One month is considered elapsed when the calendar month has increased
and the calendar day and time is equal or ...
- 5,741
0
votes
0
answers
34
views
How to create a file in another server using T-SQL
I have 2 servers; one server hosts a SQL Server (which is a Windows machine), and the other one is a linux system.
I want to export the data from the SQL Server instance to linux system. While I was ...
- 337
0
votes
0
answers
50
views
Need to Get the no.of records Inserted in Sql Table in last 10 days
In my table I didn't have primary key and forgot to add timestamp column. Now I would need to find the records with date time of insertion in last 10 days. Is there a way to find this? If yes then how?...
- 333
0
votes
0
answers
15
views
Azure Pipeline timeout with testcontainers
I have a similar issue as this: Testcontainers: Azure pipeline test stage reach timeout of 1hour
I would have commented there but I can't comment because I don't have 50 reputation.
It's the same case,...
- 11
-2
votes
0
answers
50
views
Why am I getting the wrong value or NULL after doing left joins? [closed]
I have a table called Persons with an ID column. I have another table called Cases which has an ID, another PersonID, and the date that the case was made. I have a third table called PersonsCases, ...
- 1
0
votes
0
answers
48
views
Improve performance or change query so it can be an indexed view
We have this query in a non-indexed view in SQL Server 2022.
It's used everywhere and I'm trying to improve the performance. A lot of queries we use elsewhere join to it.
My thought was whether there'...
- 786
0
votes
0
answers
34
views
Unable to Connect to Azure SQL Server Database Using JDBC Driver in Android App
I'm developing an Android app and trying to connect to an Azure SQL Server database using the JDBC driver. I'm encountering a java.lang.AssertionError related to SSL/TLS communication. Below is the ...
- 1
-3
votes
0
answers
23
views
Can not connect to SQL Server [duplicate]
I try to change IP address and restart the SQL Server at services.msc, reload too many time, and I get this error:
TITLE: Connect to Server
Cannot connect to DESKTOP-1GSM5LI\ZUN.
ADDITIONAL ...
- 1
-4
votes
0
answers
32
views
Validating rules [closed]
I've a table data:ORG ER |ACT | BUD N |ACT N_1
I identify the cases where I need to identify the ORG ER which will be rejected and I need to insert it in a table of reject.
Here the rule 1 that ...
- 45
0
votes
1
answer
39
views
Get all hierarchy in SQL Server
I have a table like this:
ID_employee
ID_Manager
1
1
2
1
3
1
4
2
5
3
6
5
7
5
8
5
(1 is a boss)
What I would like is a result like:
ID_employee
ID_Manager
8
5
8
3
8
1
7
5
7
3
7
1
6
5
...
- 27
-2
votes
0
answers
16
views
i have this error The page cannot be displayed because an internal server error has occurred [closed]
When I uploaded the site to the host, there was no problem. But when we are working with the site. For example, we return to the main page or perform a delete operation, this error occurs!
I ...
- 11
0
votes
0
answers
18
views
Uipath connect to SQL Server and use bulkinsert - get System.Exception error
I have an Excel file with 750,000 records. I first use read range to load it into a data table.
To avoid issues with large volumes of data, I used a For Each loop to split the data and perform bulk ...
- 1
0
votes
0
answers
34
views
TinyTDS Login failed when TSQL connects -
I have a RoR API only app:
gem 'rails', '~> 7.0.8'
gem 'activerecord-sqlserver-adapter', '7.0.7'
gem 'composite_primary_keys', '14.0.9'
gem 'tiny_tds', '2.1.7'
The ubuntu server connects just fine ...
- 3,066