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:
/ shaheer-ahmad-ch
Link to Download SQL:
www.microsoft.com/en-us/sql-s...
Link to Download Gateway:
www.microsoft.com/en-us/downl...
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