TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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
Reply
Answers (
4
)
i have one doubt for sql insert statement
i have one doubt for stored procedure