Call a SQL Server Stored Procedure using Excel Parameters

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

★☆★ Join this channel to get access to perks: ★☆★

#SQL #analytics #tsql #excel #dataanalyst #data

★☆★ FOLLOW ME BELOW: ★☆★
  1. Anthony Smoak
  2. Excel
  3. Parameters
  4. excel tips and tricks
  5. excel tutorial
  6. learn sql
Рекомендации по теме
Call a SQL 0:13:26

Call a SQL Server Stored Procedure using Excel Parameters

C# How 0:07:43

C# How to call a SQL Server stored procedure

Advanced SQL Tutorial 0:06:15

Advanced SQL Tutorial | Stored Procedures + Use Cases

SQL Stored Procedures 0:44:34

SQL Stored Procedures - What They Are, Best Practices, Security, and More...

SQL Server Stored 0:10:38

SQL Server Stored Procedure - How To

Stored procedures in 0:20:11

Stored procedures in sql server Part 18

SQL Server Stored 0:09:21

SQL Server Stored Procedures with input parameters

How to Write 0:07:37

How to Write Stored Procedure in SQL Server for Beginners

Sql DBA Batch 0:00:00

Sql DBA Batch 56 Class 6 Full Discussion on Sql Server 2019 Installation || Contact +91 9902590140

How to optimize 0:04:02

How to optimize a Stored Procedure or SQL Query ?

Calling SQL Server 0:03:48

Calling SQL Server Stored Procedures from a REST API

SQL Stored Procedures 0:06:16

SQL Stored Procedures | CREATE PROCEDURE Statement| SQL Server Tutorial for Beginners

Procedure Tutorial in 1:06:21

Procedure Tutorial in SQL | SQL Stored Procedure | Procedure in SQL

Create Stored procedure 0:03:32

Create Stored procedure & Create Function in Sql , How to call function from stored procedure

Passing Large Datasets 0:06:20

Passing Large Datasets into SQL Server Stored Procedures

SQL Server Stored 0:03:07

SQL Server Stored Procedures using sp HelpText to see stored procedure code

Stored Procedure With 0:09:35

Stored Procedure With a Return Value in SQL Server

Debugging sql server 0:15:11

Debugging sql server stored procedures

How I Set 0:07:03

How I Set Up To Tune SQL Server Stored Procedures

Call any web 0:20:15

Call any web api & Service From MS SQL Server

SQL Server - 0:06:43

SQL Server - INSERT RECORDS INTO TABLE VIA STORED PROCEDURE AND DEFAULT VALUES

16-How to create/execute/test 0:02:42

16-How to create/execute/test a stored procedure using Microsoft SQL Server Database

Tutorial 9- MYSQL 0:10:01

Tutorial 9- MYSQL Stored Procedures -MySQL Complete Playlist

How to Use 0:10:21

How to Use a SQL Server Stored Procedure in a Power BI Module

Комментарии
Автор

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.

justuju
Автор

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

oussamakherroub
Автор

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

HerbertWoelffer
Автор

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

devendrateluguchannel
Автор

I cant get my button to execute I click it and nothing I tried this 3 times and I dont see anything wrong

jaygibbs
Автор

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.

jdwyer
Автор

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

emmanuel.aggrey
Автор

Very nice but the video is fast. Please see if you can make it go slow.

mnvsaikiran