Have a Question?

If you have any question you can ask below or enter what you are looking for!



Stored Procedure SQL

I have to Insert data in already created column and need to create a store procedure to avoid repeated steps. Please help me out.

As per below  I have to insert data in "Joining_Date", "Department" and "Gender"?

If we can't enter the date for all three columns, please suggest to enter data in single column "Joining_Date"?



  Rupesh Kumar

Hi, 

I din't get understand what steps you are talking about. As far as i understood you can use below procedure to

update the records-

create procedure update_Table 
@DOJ date,
@sal bigint,
@deptno int,
@empno int

as

update employee
set Hiredate = @DOJ, sal = @sal, DeptNo = @deptno

where EmpNo = @empno

To execute this procedure you can use -

execute update_Table '1980-12-19',800,20,7369

Please reply if you are looking for something else.


Thanks,

  Devbrat Tripathi       31 Aug 2016       0       0     

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any