filmov
tv
Lesson 3 - Create a Lookup of key values from SQL Server using SQL Spreads
Показать описание
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.
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.