conditions in stored procedure

[magmo]

Hi


Is it possible to check if a value in a stored procedure is "" and if so not make an update.

    UPDATE
        tbl_database
    SET
      txt1 = @txt1,
      txt2 = @txt2,
    WHERE
       (ID = @ID)

Lets say for example that @txt1 is "" then I don't want to make any update for txt1. Is this possible?



Regards

 

[SQLDenis]

if @txt1 <> ''
begin
UPDATE
tbl_database
SET
txt1 = @txt1,
txt2 = @txt2
WHERE
(ID = @ID)
end
else
begin
UPDATE
tbl_database
SET
txt2 = @txt2
WHERE
(ID = @ID)

end

Or you would have to use dynamic SQL

“I sense many useless updates in you... Useless updates lead to defragmentation... Defragmentation leads to downtime...Downtime leads to suffering..Defragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/