Create and Connect a SQL Server Stored Procedure with Canvas Application | Power Apps | Step by Step

365Connect Community
365Connect Community
250
0
Published 2024-06-21
This video provides a step-by-step guide on how to create a SQL Server and connect it to a Canvas application. Learn how to set up your server, configure it properly, and establish a secure connection to your Canvas app. Whether you're a beginner or an experienced developer, this tutorial covers all the essential steps to get your SQL Server up and running with Canvas.

Duration: 1593.77 minutes.

Shaheer Ahmad:
www.linkedin.com/in/shaheer-ahmad-ch/

Link to Download SQL:
www.microsoft.com/en-us/sql-server/sql-server-down…

Link to Download Gateway:
www.microsoft.com/en-us/download/details.aspx?id=5…

Query to Create the Stored Procedure:

CREATE PROCEDURE SearchEmployees
@SearchText NVARCHAR(100) = NULL
AS
BEGIN
SELECT *
FROM Employees
WHERE (@SearchText IS NULL OR @SearchText = '')
OR (FirstName LIKE '%' + @SearchText + '%'
OR LastName LIKE '%' + @SearchText + '%' + @SearchText + '%');
END;

Hashtags:
#SQLServer #CanvasApp #SQLServerTutorial #DatabaseSetup #CanvasIntegration #TechTutorial #StepByStepGuide #PowerApps #Shaheer365 #ShaheerAhmad #365ConnectCommunity #StoredProcedure
All Comments (4)