I want to create a procedure to update a table. It takes number of input parameters(one of them is the @pID) and updates four columns which have the pID=@pID and only one of these four columns can be updated if the value of another column='F' in addition to pID=@pID. How can I do this?
This is what I've got so far
CREATE PROCEDURE ABC (
@pID
@A INT,
@B CHAR,
@C CHAR,
@D VARCHAR)
AS
update EEE
set A=@A,
B=@B,
C=@C
WHERE pID=@pID
update EEE
set D=@D
Where pID=@pID AND G='T'
It looks like what you have is correct. It makes no sense whatsoever but it seems functional.
the code which u ve written is correct for stored procedure, i dont really understand wats ur problem is....
Thanks a lot. There was an error but I got it work.
You're welcome even though we didn't do much :)
Please mark this thread as solved since you have found a solution to your problem and good luck!
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.