Eswar Datta

Eswar Datta

  • NA
  • 115
  • 7.5k

WebService and jquery ajax

Oct 15 2018 8:03 AM
ALTER PROCEDURE [dbo].[ASP_INSERT_CATEGORY](@CATEGORY_NAME NVARCHAR(MAX),@CATEGORY_DESCRIPTION NVARCHAR(MAX))
AS BEGIN
DECLARE @COUNT INT
SELECT @COUNT = COUNT(CATEGORY_NAME) FROM PARES_MASTER_CATEGORIES WHERE CATEGORY_NAME=@CATEGORY_NAME
IF(@COUNT>1)
BEGIN
SELECT 1 AS ALREADY_SAVED
END
ELSE
BEGIN
INSERT INTO [PARES_MASTER_CATEGORIES] (CATEGORY_NAME,CATEGORY_DESCRIPTION,STATUS) VALUES(@CATEGORY_NAME,@CATEGORY_DESCRIPTION,1)
END
END
 
 
 
How to create webservice and call that with jquery ajax. 

Answers (1)