> adminpass = @adminpass1,
> WHERE adminname = @adminpass1

"Eselyn" <eselyn@time.net.my> wrote in message
news:10a5001c3f431$b75965d0$a001280a@phx.gbl...
> CREATE PROCEDURE dbo.updateadminpass
> (
> @adminname1 nvarchar(50) ,
> @adminpass1 nvarchar(50)
> )
> As
>
> UPDATE admin SET
> adminpass = @adminpass1,
>
> WHERE adminname = @adminpass1
>
> GO
> well here is my coding. I'm new learner in sql.Please tell
> me where is my mistake.
> Thanx in advance

"Itzik Ben-Gan" <itzik@REMOVETHIS.solidqualitylearning.com> wrote in message news:<eK2H3LD9DHA.1816@TK2MSFTNGP12.phx.gbl>...
> Eselyn,
>
> > adminpass = @adminpass1,
> > WHERE adminname = @adminpass1
>
> Remove the comma right before the WHERE clause.
>
> --
> BG, SQL Server MVP
> Principal Mentor, Solid Quality Learning
> www.SolidQualityLearning.com
> More than just Training...
>
>
> "Eselyn" <eselyn@time.net.my> wrote in message
> news:10a5001c3f431$b75965d0$a001280a@phx.gbl...
> > CREATE PROCEDURE dbo.updateadminpass
> > (
> > @adminname1 nvarchar(50) ,
> > @adminpass1 nvarchar(50)
> > )
> > As
> >
> > UPDATE admin SET
> > adminpass = @adminpass1,
> >
> > WHERE adminname = @adminpass1
> >
> > GO
> > well here is my coding. I'm new learner in sql.Please tell
> > me where is my mistake.