Inserting data into SQL Server is a fundamental operation for business users who need to add new records to their databases. This guide will walk you through the process of using the INSERT statement in SQL Server, providing comprehensive steps and code snippets you can use directly in SQL Server Management Studio (SSMS). Understanding the …
The Excel and SQL Server experts blog
-
How to perform an INSERT in SQL Server
Johannes Åkesson - Aug 01, 2024 -
How to perform a DELETE in SQL Server
Johannes Åkesson - Aug 01, 2024Deleting data in SQL Server is a critical operation for business users who need to remove obsolete or incorrect records from their databases. This guide will walk you through the process of using the DELETE statement in SQL Server, providing comprehensive steps and code snippets you can use directly in SQL Server Management Studio (SSMS). …
-
How to create a database in Excel
Johannes Åkesson - Aug 01, 2024Creating a database in Excel is a straightforward process that can help you manage and analyze your data efficiently. Whether you need to keep track of personal information, business records, or project details, Excel offers powerful tools to build and maintain a database. Follow these steps to create a database in Excel: 5 steps on …
-
How to perform a SELECT INTO in SQL Server
Johannes Åkesson - Aug 01, 2024The SELECT INTO statement in SQL Server is a powerful tool for creating new tables and copying data from existing tables or queries. This guide will walk you through the process of using the SELECT INTO statement in SQL Server, providing comprehensive steps and code snippets you can use directly in SQL Server Management Studio …
-
How to perform an UPDATE in SQL Server
Johannes Åkesson - Jun 28, 2024Updating data in SQL Server is a common task for business users who need to ensure their data remains accurate and up-to-date. This guide will walk you through the process of using the ‘UPDATE’ statement in SQL Server, providing easy-to-follow steps and code snippets you can use directly in SQL Server Management Studio (SSMS). Understanding …
-
How to insert data from Excel to SQL Server
Johannes Åkesson - Jun 04, 2024Most people do not know that there is a really simple way to copy and paste data from Excel to SQL Server. In this article, I will show you what you need to know to copy and paste data from Excel to SQL Server.
I will go through and show the technique using simple step-by-step instructions, and I will also cover a few special cases that are great to know. -
How to Build a KPI Dashboard with Power BI
Andy McDonald - May 21, 2024In this article, we’re going to show you how to build a KPI dashboard in Power BI for managers. The example we’ll work through uses our KPI data collection template, used by operational level administrators to collect KPI metrics. This template was built with SQL Server, Excel and the SQL Spreads Excel Add which is …
-
SQL Spreads release 7.4.1
Johannes Åkesson - Mar 29, 2024We’re excited to announce the latest enhancements and fixes in SQL Spreads to make your data management experience smoother and more secure. Here’s what’s new in SQL Spreads 7.4.1: Enhanced Tree Filters: Tree Filters have been improved and are now shown only for individual Excel sheets, and changes in a Tree Filter only refresh the …
-
Use Case: How to build a KPI Excel template with SQL Server
Andy McDonald - Mar 06, 2024In this article, we’re going to show you how to build a KPI Excel template using SQL Server and an Excel Add-In. Many organizations collect performance metrics related to aspects of their business and then use KPIs to measure and track performance against targets. However, the process of collecting the data is often a manual …
-
Temporal Tables and how to use them in SQL Server
Andy McDonald - Feb 01, 2024If you want to keep track of when changes were made to your data, or see how data changes over time, you need to start using temporal tables in SQL Server. Microsoft introduced this great feature in the 2016 version of SQL Server, but is still relatively unknown. A common associated challenge with tracking changes …
Product
Key features
Use Cases
Compare SQL Spreads
Resources
Doc
Support
Company
Subscribe for updates
×
×