Amudhan Kuppan

Amudhan Kuppan

  • NA
  • 378
  • 29.9k

i have doubt for stored procedure

Mar 5 2018 3:30 AM
hi,
iam amudhan
anyone please help me 
iam execute stored procedure query i got some error please help me
 
ALTER Procedure [dbo].[InsertStudentrecord]
(
@ID int,
@FirstName Varchar(50),
@LastName Varchar(50),
@DateOfBirth datetime,
@FatherName varchar(50),
@MotherName varchar(50),
@Gender varchar(50),
@Height decimal(18,0),
@Weight decimal(18,0)
)
As
Begin
Insert into Student (ID,FirstName,LastName,DateOfBirth,FatherName,MotherName,Gender,Height,Weight)
Values(@ID,@FirstName,@LastName,@DateOfBirth,@FatherName,@MotherName,@Gender,@Height,@Weight)
End
 
this is my query iam executing the query i will get completed successfully after i will insert the data in a table i got one error please rectify it 
 
Msg 8114, Level 16, State 5, Procedure InsertStudentrecord, Line 2
Error converting data type nvarchar to datetime.
(1 row(s) affected)
 
this is error

Answers (4)