store procedure in sql
A stored procedure is a set of Structured Query Language (SQL) statements with an assigned name, which are stored in a relational database management system as a group, so it can be reused and shared by multiple programs.
Example :
Create store procedure to fetch country details by passing to argument city and Country
CREATE PROCEDURE [dbo].[GetCustomerData]
@city nvarchar(max),
@country nvarchar(max)
AS
Select * from Customers
where
City like '%'+ @city +'%' or
Country like '%'+ @country +'%'
Example :
Create store procedure to fetch country details by passing to argument city and Country
CREATE PROCEDURE [dbo].[GetCustomerData]
@city nvarchar(max),
@country nvarchar(max)
AS
Select * from Customers
where
City like '%'+ @city +'%' or
Country like '%'+ @country +'%'
![CORS - Access-control-allow-origin header not present [SOLVED]](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_uwGA7qkzd6Kx6FT-1_P9KC487U81WEErPHgiKcDxlpoFH81hEDbI6xTzfdKeAfFsPwnZbTVsEhSv4jJIYSUrPfviHQymFyDI9E4uo)
No comments