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_sGov5vADwbDF1xFzrRHz1FwPiD8MPFu504zgnR5OLV2y0mgZaKChYZUthVOUtJMBe5J5q6H241ZhilslGZHnF7kAEUdT5-fmH3QA8)
No comments