Subject | Stored Proc Problems |
---|---|
Author | custom_soft_sol |
Post date | 2002-08-21T19:05:39Z |
Hi All
I have the following SP that doesn't seem to want to work
create procedure UpdateUsers ( In_UserName VARCHAR(50) )
as
begin
UPDATE SYSUSERS
SET LOGGEDINTIME = CURRENT_TIMESTAMP
WHERE USERNAME = In_UserName;
end
If I run the Update by itself it works properly.
What am I doing wrong.
Thanks
I have the following SP that doesn't seem to want to work
create procedure UpdateUsers ( In_UserName VARCHAR(50) )
as
begin
UPDATE SYSUSERS
SET LOGGEDINTIME = CURRENT_TIMESTAMP
WHERE USERNAME = In_UserName;
end
If I run the Update by itself it works properly.
What am I doing wrong.
Thanks