Create and Connect a SQL Server Stored Procedure with Canvas Application | Power Apps | Step by Step
2024-06-21に共有
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