how to insert the data into table in storedprocedure

Accepted answer

Create Procedure insertdata @id int, @name nvarchar(50), @age int As If not exist(select * from table where id=@id) Begin Insert into table(id,name,age) Values(@id,@name,@age) End

Sai Kumar Koona8y ago

Hi what jignesh is given good way. If you are looking to do in single statement you can do it likeInsert into employees(empname) values(@empname) Where (select 1 from employees where empid = @empid) = 0

Jenith Thakkar8y ago

If my answer was helpful for you then please accept it

Jignesh Kumar8y ago

Please use If Not Exists it for check existing erocrd in table

CREATE PROCEDURE usp_InsertEmployeeDetails
@empId int,
@EmpName varchar(200),
@EmpCity varchar(100)
As
BEGIN
If Not Exists(select 1 from Employee where empId = @EmpId)
BEGIN
insert into Employee(EmpName,EmpCity) values(@EmpName,@EmpCity)
END
ELSE
BEGIN
print 'Employee Already Exist'
END
END