Build Dynamic SQL in SQL Server

Подписаться 23 тыс.

Просмотров 6 тыс.

50% 1

In this video you will learn how to build dynamic SQL using TSQL and SQL Server without the headaches. Using the sp_executesql command we eliminate some of the risks associated with SQL injection attacks thanks to embedded parameters.
★☆★ SUPPORT THIS CHANNEL: ★☆★
shop.spreadshirt.com/AnthonySmoak
★☆★ FOLLOW ME BELOW: ★☆★
Blog ► anthonysmoak.com/
Twitter ► / anthonysmoak
Facebook ► /
Tableau Public ► public.tableau.com/profile/an...
#SQL #SQLServer #data #analytics #data #dataanalyst #education #onlinelearning

Опубликовано:

3 май 2021

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

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

@dizetoot 3 года назад

Loving that you're doing technologies other than tableau 🙌🏾

@AnthonySmoak 3 года назад

Thanks, you have to know how to work the data on the backend too!

@wg8304 2 года назад

@@AnthonySmoak ahh now the question is where is the video discussing server stored procedures in Tableau?

@Isaiah094 3 года назад

Very useful. Thank you so much. I wondering, can we store this in an SP and leave the @StateInput = ‘’ or a space and then use the SProc GUI to populate the value within that parameter? I guess it’s the same thing but it’s more ‘user friendly’ that way.

@AnthonySmoak 3 года назад

Good question. Never tried to bring it up in the GUI. Give it a try and let us know!