Questions about sql-server-2014
Read more about sql-server-2014
python (65.2k questions)
javascript (44.3k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (13k questions)
Inverse format function
Is there an inverse format function in SQL Server ?.
I have to import some datetime values as 'yyyyMMddTHHmmss' strings (example '20220406T123043' for the 06/04/2022 12:30:43), but I cannot convert ea...
Marc Guillot
Votes: 0
Answers: 1
T SQL Extract String between penultimate and last comma
I'm using MS SQL Server 2014 SP3.
I have a column called person_loader that contains one large string. I have no control over this as its from a 3rd party system.
Sample data:
1. Bob Smith, 01/01/198...
Michael
Votes: 0
Answers: 1
Need query to join table on column with comma separated
Table1
ID
Notes
ReasonID
1
Test1
[11,12]
2
Test2
[13,14]
Table 2
Reasonid
Name
11
Other1
12
Other2
13
Other3
14
Other4
Result should look like this, where Notes column ...
zzstar
Votes: 0
Answers: 3
From SQL Server 2014 to SQL Server 2019 - No backupset selected to be restored
From a Windows Server 2012 / SQL Server 2014, I backed up a database to a NNNN.bak file on a network drive. When I log in to my new Windows Server 2019 / SQL Server 2019 and try to restore that, I get...
AAserver
Votes: 0
Answers: 1