Call a SQL Server Stored Procedure using Excel Parameters

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

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

50% 1

Sometimes we need to dynamically transfer data from SQL Server into Excel without the manual cutting and pasting. By the end of this video, you'll know how to use sp_executesql and parameters to pass data between Excel and SQL Server. Unlike the first video where I demonstrated using a raw SQL query, parameterized queries can improve query performance by avoiding the need for the database engine to compile the same query multiple times. Additionally, sp_executesql is more secure, as it helps prevent SQL injection attacks.
Watch Part 1 for worksheet details and for the quick way to retrieve data: • Passing Parameter Valu...
★☆★ Join this channel to get access to perks: ★☆★
/ @anthonysmoak
#SQL #analytics #tsql #excel #dataanalyst #data
Download the Database used in the video: learn.microsoft.com/en-us/sql...
★☆★ FOLLOW ME BELOW: ★☆★
Blog ► anthonysmoak.com/
Instagram ► / @anthonysmoakdata
Facebook ► / anthonybsmoak
Tableau Public ► bit.ly/3JMKsLY

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

3 янв 2023

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@abdullahquhtani4247 Год назад

Thank you very much. 👍🏼

@Faisal1504

Very nice.

@oussamakherroub1103 Год назад

Thank you for this video it works perfectly, but i have the error 438 when we run this macro in an other PC

@justuju

Hey Anthony nice video. What do I need to do if instead of details I want to do pivot table representation? meaning I want to do all this, but then data needs to be transformed to a pivot table without user interaction.

@devendrateluguchannel Год назад

how to create stored procedure please give me a video step by step .....

@HerbertWoelffer Год назад

Followed everything. Runs great on mine but some other users get runtime error 1004 on the refresh line of the macro. Thoughts?

@emmanuel.aggrey Год назад

thanks for the video, please can share this file with us so we can edit it according to our need or share the code you pasted. I will be much greafull thank you sir

@jdwyer4851

how is this in anyway better than MSQuery where i could just do {Call MyStoredProcedure(?,?,?)}. Not a bit of VBA or a macro, i could just assign the 3 parameters to cells on the sheet.