Bucheli
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment