i have one doubt for stored procedure

Amudhan Kuppan

8y999SQL

hi,

iam amudhan,

anyone please help me i will send document i have got one error

after iam executing stored procedure i have got one error anyone please help me

i will send document please check it is right or wrong

15 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tripat Bala Singh8y ago
Accepted answer
write like this @DateOfBirth = N'07/20/1998'
if your data type of DateOfBirth is datetime
then save like this 1998-07-20 00:00:00.000
and if data type of DateOfBirth is nvarchar
then save like this 07/20/1998
and if data type of DateofBirth is date
then save like this 1998-07-20
+3
Amudhan Kuppan8y ago
thank you tripat bala singh
0
Amudhan Kuppan8y ago
thank you piyush
0
Amudhan Kuppan8y ago
now its work fine piyush thank you
0
Piyush Pansuriya8y ago
Hi,
This is not an Error, your SP execute successfully.
Please check into your Student table weather record is inserted or not.
0
Amudhan Kuppan8y ago
hi piyush
that also iam try no change i will send file please see piyush
0
Amudhan Kuppan8y ago
ok piyush i will try after let you know
0
Piyush Pansuriya8y ago
Hi, Try this :
@DateOfBirth = 'yyyy-MM-dd'

And No need to convert into date while inserting.

(ID,FirstName,LastName,DateOfBirth,FatherName,MotherName,Gender,Height,Weight)
Values(@ID,@FirstName,@LastName,@DateOfBirth,@FatherName,@MotherName,@Gender,@Height,@Weight)
0
Amudhan Kuppan8y ago
hi piyush i will send code please check
USE [IT TEST]
GO
/****** Object: StoredProcedure [dbo].[InsertStudentrecord] Script Date: 03/06/2018 09:27:18 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:
-- Create date: <05/03/2018>
-- Description:
-- =============================================
ALTER Procedure [dbo].[InsertStudentrecord]
(
@ID int,
@FirstName nVarchar(50),
@LastName nVarchar(50),
@DateOfBirth date,
@FatherName nvarchar(50),
@MotherName nvarchar(50),
@Gender nvarchar(50),
@Height decimal(18,0),
@Weight decimal(18,0),
@StatementType nvarchar(20) = ''
)
AS
BEGIN
IF @StatementType = 'Insert'
BEGIN
Insert into Student (ID,FirstName,LastName,DateOfBirth,FatherName,MotherName,Gender,Height,Weight)
Values(@ID,@FirstName,@LastName,convert(date,@DateOfBirth),@FatherName,@MotherName,@Gender,@Height,@Weight)
END
else IF @StatementType = 'Update'
BEGIN
UPDATE Student SET
FirstName = @FirstName, LastName = @LastName, DateOfBirth = @DateOfBirth, Fathername = @FatherName, MotherName = @MotherName,Gender = @Gender, Height = @Height,Weight = @Weight
WHERE ID = @ID
END
end
0
Amudhan Kuppan8y ago
iam use datatype of @dateofbirth is date only i will send sp query please check
USE [IT TEST]
GO
/****** Object: StoredProcedure [dbo].[InsertStudentrecord] Script Date: 03/06/2018 09:27:18 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:
-- Create date: <05/03/2018>
-- Description:
-- =============================================
ALTER Procedure [dbo].[InsertStudentrecord]
(
@ID int,
@FirstName nVarchar(50),
@LastName nVarchar(50),
@DateOfBirth date,
@FatherName nvarchar(50),
@MotherName nvarchar(50),
@Gender nvarchar(50),
@Height decimal(18,0),
@Weight decimal(18,0),
@StatementType nvarchar(20) = ''
)
AS
BEGIN
IF @StatementType = 'Insert'
BEGIN
Insert into Student (ID,FirstName,LastName,DateOfBirth,FatherName,MotherName,Gender,Height,Weight)
Values(@ID,@FirstName,@LastName,convert(date,@DateOfBirth),@FatherName,@MotherName,@Gender,@Height,@Weight)
END
else IF @StatementType = 'Update'
BEGIN
UPDATE Student SET
FirstName = @FirstName, LastName = @LastName, DateOfBirth = @DateOfBirth, Fathername = @FatherName, MotherName = @MotherName,Gender = @Gender, Height = @Height,Weight = @Weight
WHERE ID = @ID
END
end

0
Piyush Pansuriya8y ago
Hi,
Paste your SP to find where you are missing..
0
Tripat Bala Singh8y ago
Hello Amudhan Kuppan
tell me you have which type of datatype of @DateOfBirth.
0
Amudhan Kuppan8y ago
thats also iam tried piyush but no change
0
Piyush Pansuriya8y ago
Hi,

Write date of birth parameter in single quote.
Like : @DateOfBirth = N'1998-07-20'
0
Amudhan Kuppan8y ago
this is code document please see
0