Sql Server Stored Procedure for insert values into table rows
Create Procedure SP_insert
@EMP_ID NVarchar(20),
@Emp_name nvarchar(40),
@Emp_Sal Nvarchar(30)
AS
BEGIN
Insert into Employee_Desg(EMP_ID,
EMP_Name,EMP_Sal)Values(@EMP_ID,
@Emp_name,@Emp_Sal)
END
select * from Employee_Desg
Exec SP_insert 'T0003','kumar','30000'