Lesson 3 - Create a Lookup of key values from SQL Server using SQL Spreads

Lesson 3 - Create a Lookup of key values from SQL Server using SQL Spreads

SQL Spreads

1 год назад

1,260 Просмотров

In this video we will show you how to create a lookup of key values from a related table in SQL Server using SQL Spreads.

00:00 Intro
00:15 Lookup a key value in a database table
01:20 Lookup a key value in a simple list of key-value pairs
02:19 Summary

The key values in Excel will be replaced with a drop-down list that shows texts fetched from the related table in SQL Server.

We will also create lookup of key values from a simple list of keys and texts in SQL Spreads.

Learn more about using Excel to update data in SQL Server and download the 14-days Free Trial at https://sqlspreads.com
Ссылки и html тэги не поддерживаются


Комментарии: