Excel LET Formula for creating small values tables from a table or range
The Excel (365) "LET" formula below will return a formatted SQL Values Table "T1" that can be pasted into SSMS.
2022-04-06 (first published: 2022-03-29)
726 reads
Excel
Import Excel Data into SQL Server with PowerShell
In this article we look at PowerShell code you can use to import Excel data into SQL Server.
2021-01-05
Export SQL Server Data to Multiple Excel Worksheets with C#
In this article we look at how to export data from different SQL Server tables or queries into multiple Excel sheets in the same file.
2020-12-07
Analyze SQL Server Results in Excel with Conditional Formatting
Learn how to format your SQL Server results in Excel using conditional formatting to quickly identify patterns and issues.
2020-03-10
Blogs
Encrypting Your SQL Data Should be Your Default Option
Cyber-attacks and data breaches seem to be perpetually on the rise. Every week we...
Power BI Embedded: Using Row-Level Security for Multilingual Reports
By DataOnWheels
Making multilingual reports in Power BI requires a lot of different elements. Translations can...
Daily Coping 29 Nov 2022
By Steve Jones
Today’s coping tip is to make a meal using a recipe or ingredient you’ve...
Forums
Why do Sql Server In operator behaves differently and return nothing?
I am using sql server 2017. I am trying to use the in operator,...
Basic Checks on a New AWS RDS SQL Server
Comments posted to this topic are about the item Basic Checks on a New...
Assigning a Server Role
Comments posted to this topic are about the item Assigning a Server Role
Ask SSC