stored procedure ...help!!:)
-
:)I need to make UPdate stored procedure... like this.. create proc update_user (@user_name nvarchar ,@password nvarchar, @firstname nvarchar ,@lastname nvarchar) update Users set [password]=@password (but if @password=empty string then keep no change in db column "password" ) and update other fields .. thanks
-
:)I need to make UPdate stored procedure... like this.. create proc update_user (@user_name nvarchar ,@password nvarchar, @firstname nvarchar ,@lastname nvarchar) update Users set [password]=@password (but if @password=empty string then keep no change in db column "password" ) and update other fields .. thanks
Retrieving old password and keep it in a variable or session. use the condition stmt in the asp.net. For eg: if txtpass.text="" then cmd.parameter.add("@password",session("pass")) else cmd.parameter.add("@password",txtpass.text) end if Hope this will help to solve your prob.
-
:)I need to make UPdate stored procedure... like this.. create proc update_user (@user_name nvarchar ,@password nvarchar, @firstname nvarchar ,@lastname nvarchar) update Users set [password]=@password (but if @password=empty string then keep no change in db column "password" ) and update other fields .. thanks
Simple way: create procedure update_user @user_name nvarchar(20), @password nvarchar(20), @firstname nvarchar(20), @lastname nvarchar(20) as if @password is null or @password='' update Users set firstname=@firstname, lastname=@lastname where user_name=@username else update Users set firstname=@firstname, lastname=@lastname, password=@password where user_name=@username
-
:)I need to make UPdate stored procedure... like this.. create proc update_user (@user_name nvarchar ,@password nvarchar, @firstname nvarchar ,@lastname nvarchar) update Users set [password]=@password (but if @password=empty string then keep no change in db column "password" ) and update other fields .. thanks