Tuesday, 13 August 2013

Update check t-sql

Update check t-sql

Hi have procedure where update table.
UPDATE myTbl
SET pswd = @newPswd
where id = @id and pswd = @pswd
now want check
if pswd <> @pswd
print 'error'
how do it ? when i write it after where have an error invalid column

No comments:

Post a Comment