Hi every one,
I have stored procedure created
USE [WAAS]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Procedure [ADD_RECORDS]
(
@GrpId bigint,
@DispName varchar(50),
@FullName varchar(50),
@LastValue varchar(50),
@ActiveDirName varchar(50),
@ClassVal int,
@UID varchar(15)
)
As
BEGIN
INSERT INTO table(GrpId,
DispName,
FullName,
LastValue,
ActiveDirName,
ClassVal,
CreatedBy,
CreatedDt)
VALUES(@LobGrpId,
@DispName,
@FullName,
@LastValue,
@ActiveDirName,
@ClassVal,
@UID,
GETDATE())
END
This is my stored procedure created to add records into database.
Now I would like to update the details by writing the update query to update the values in the same stored procedure.
values needs to be updated:
LobGrpId
FullName
ActiveDirName
ClassificationVal
UID
updatedby
updatedtime
Can anyone help me?
Thanks in advance