Wednesday 15 September 2010

IF THEN clause in SQL Server 2008 -


I am a newbie with this and I do not understand that when I execute this archived procedure I get an error.

Can anyone help me? 

  Optional process [dbo]. [Update_UserPassword] (@Name Encryption (50), @Powered Encryption (20)) Start DECLARE @flag bit SET NOCOUNT ON; SET @flag = (user WHERE user name = @ userlog select firstloginflag) - For here the procedure IF (@flag = 0) set the URI firstloginflag = 1, password = @password WHERE user name = @ user name ELSE UPDATE USER SET Password = @ Parsvard WHERE User Name = @ User Name END   
 This error is:  
 
 Message 208, Level 16, State 6, Process Update_UserPassword, line 31 
 Invalid object name 'dbo.Update_UserPassword'.    
 
 
 There is no current  update_userpaceword in current database and / or schema  stored procedure  
 You are either in the wrong data base and need to execute a  use [database name]; , incorrect schema means which means that you need to include the schema name -  [schema] .Update_UserPassword , or  change process  by a < Change to Code> Change Process .   

 








Posted by



at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)