Alberto Martinez
  • Member for 9 years, 9 months
  • Last seen more than a week ago
MDF Backup: "Login failed" Error
Accepted answer
7 votes

Backups in SQL Server don't work that way, they aren't just copies of the database files in another location but instead they are backups of the database content stored in a backup file with a ...

View answer
Enable TLS 1.2 for SQL Server 2016 database mail
4 votes

It's odd because the linked article clearly states: Support for TLS v1.2 included in the .NET Framework version 3.5 SP1 on Windows 8.1 and Windows Server 2012 R2 which contradicts the response you ...

View answer
T-SQL: how to show the corresponding column's row to an aggregating function's result?
Accepted answer
1 votes

You can use the over () clause, which allows you to return the aggregate value in each row of the results without using group by. You create another subquery using over (), and then compare the value ...

View answer
SQL query does not recognise derived table
Accepted answer
1 votes

Before answering the question, you are using WHERE instead of JOIN for joining the tables, and join the tables using the company name instead of the row ID / primary key. It's better use JOIN with row ...

View answer