Build Dynamic SQL in SQL Server

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

[@dizetoot]

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

[@AnthonySmoak]

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

[@wg8304]

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

[@Isaiah094]

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]

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

[@sahiltitus8391]

Kkkkkommmkko m

[@sahiltitus8391]

Ko .o 💝😲😲💟😀😀😐