create PROCEDURE usp_insertupdatepragimcrud @EmployeeID int, @Name varchar(50), @Gender varchar(10), @City varchar(50) as begin if not exists(select * from dbo.tblEmployeeDataAccessLayer where employeeid=@EmployeeID) insert into tblEmployeeDataAccessLayer (Name,Gender,City) values (@Name,@Gender,@City) else update tblEmployeeDataAccessLayer set Name=@Name,Gender=@Gender,City=@City where employeeid=@EmployeeID end
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)