Expand|Select|Wrap|Line Numbers
- CREATE PROCEDURE [dbo].[updatestdnt]
- @Name varchar(20),
- @Course varchar(20),
- @Age numeric,
- @Sex varchar(20),
- @DateofBirth datetime,
- @Address varchar(20),
- @Contactno numeric,
- @Email varchar(20),
- @studentid varchar(10),
- @password varchar(10)
- AS
- UPDATE Student SET
- Name=@Name ,
- Course=@Course,
- Age=@Age,
- Sex=@Sex,
- DateofBirth=@DateofBirth,
- Address=@Address,
- Contactno=@Contactno,
- Email=@Email,
- studentid=@studentid,
- password=@password
- where Contactno=@Contactno
UPDATE Student SET statementappers in blue and wen i try to run this procedure in my website it says the name parameter has not been supplied?? is the procedure wrong as Name appears in blue??
and in where clause i used Contactno because its the primary key..is this where method correct??