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 …
- Product
-
-
- KEY FEATURES
- Excel to SQL Server Write-backExcel users can swiftly update and write-back data to SQL Server.
- Filter huge data setsImport large-scale data sets into Excel, even from tables with millions of rows.
- Foreign Key LookupsKey value lookups enable easy and integrity-focused relational data management for users.
- Explore all features
-
-
- Resources
- Pricing
- Company
- Try for free
- Buy now
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 -Deleting 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 perform a SELECT INTO in SQL Server
Johannes Åkesson -The 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 …
-
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 …
-
Get started with Azure SQL
Andy McDonald - Jan 26, 2024In this article, we’re going to show you how to get started with Azure SQL. Azure SQL is one of the many services offered on Azure, Microsoft’s comprehensive cloud computing platform. And it enables organizations to run workloads and develop applications in regional data centers around the globe. Introduction to Azure SQL Azure SQL is …
-
How to copy a table in SQL Server
Andy McDonald - Jul 18, 2023In this article we’re going to show you a quick and easy way to copy a table in SQL Server. The new Copy SQL Server Table feature in SQL Spreads means that you can copy a table from one database to another in just a few clicks from within Excel. Introduction Although it’s not something …
-
SQL Union: How to Combine Result Sets
Andy McDonald - Sep 02, 2022This is the sixth in a series of articles aimed at introducing the basics of SQL to Excel users. This article shows how to combine data from one or more data sets using the SQL UNION operator. UNION is one of a number of ‘set operators’ in SQL that are used to join the results …
-
What is the equivalent of the IF THEN function in SQL?
Andy McDonald - Aug 24, 2022This is the fifth in a series of articles aimed at introducing the basics of SQL to Excel users. This article shows how to use the IF THEN function in SQL. If you’re interested in the other articles, check them out here: Introduction to SQL for Excel Users What is the equivalent to VLOOKUP in …
-
What is the equivalent to VLOOKUP in SQL?
Andy McDonald - Jul 14, 2022In this article, we’re going to show you how to perform the equivalent of Excel’s VLOOKUP in SQL. This is the second of our articles aimed at teaching Excel users the basics of SQL. In our previous article “Introduction to SQL for Excel Users”, we introduced the JOIN statement, and here we’re going to expand …
-
Introduction to SQL for Excel Users
Andy McDonald - Jul 04, 2022This is the first of several articles on SQL for Excel users. The aim is to show you why it’s so useful for Excel users to be familiar with SQL and to introduce some basic concepts and queries. Why is it important to learn SQL? In a previous article, SQL and Excel: Why you need …
-
How to Use SQL with Excel for Data Analysis
Andy McDonald - Jun 08, 2022In a previous article, we talked about why most organizations should use both SQL Server and Excel for their data management needs. In this article, we’re going to look at an example of how to perform data analysis using SQL and Excel with an Excel Add-In, called SQL Spreads. You can use the Add-In to …
-
SQL and Excel: Why you need both
Andy McDonald - Mar 12, 2022SQL vs. Excel: which is better? As you can see from the title of this article, it’s not the case that you should choose one over the other; you actually need SQL and Excel. Introduction Excel is a really great application. There are not many applications that are used by such a wide variety of …
-
Simple Data Validation in SQL
Andy McDonald - Oct 24, 2021What is data validation in SQL and why is it important? Data validation is a method for checking the accuracy and quality of data. Information in databases is constantly being updated, deleted, queried, or moved by multiple people or processes, so ensuring that data is valid at all times is essential. In this article, we’re …
-
How to create Pivot Tables in SQL Server
Andy McDonald - Oct 10, 2021In this article, we’re going to show you how to create pivot tables in SQL Server. This is the third article aimed at teaching Excel users some basic SQL server queries, and how to mimic some of the main functions used in Excel. In a previous article we looked at the equivalent of Excel’s VLOOKUP …
Johannes Åkesson
Worked in the Business Intelligence industry for the last 15+ years. Founder of SQL Spreads – the data management solution to import, update and manage SQL Server data from within Excel.
Stena Center
412 92 Gothenburg
SWEDEN