Saturday, March 12, 2016

SELECT Column Value from Table to SET Variable

DECLARE @P_RET_VAL INT;

SET @P_RET_VAL = ( SELECT [PD_Id]
FROM [Products]  
WHERE [PD_No] = @PD_No
 )

Using Authorization with Swagger in ASP.NET Core

 Create Solution like below LoginModel.cs using System.ComponentModel.DataAnnotations; namespace UsingAuthorizationWithSwagger.Models {     ...