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

preview_player
Показать описание
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.

Рекомендации по теме