i have one doubt for stored procedure

Question

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

Tripat Bala Singh · 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

Piyush Pansuriya · Answer

Hi, This is not an Error, your SP execute successfully. Please check into your Student table weather record is inserted or not.

Piyush Pansuriya · Answer

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)

Piyush Pansuriya · Answer

Hi, Write date of birth parameter in single quote. Like : @DateOfBirth = N'1998-07-20'

Amudhan Kuppan · Answer

thank you tripat bala singh

Amudhan Kuppan · Answer

thank you piyush

Amudhan Kuppan · Answer

now its work fine piyush thank you

Amudhan Kuppan · Answer

hi piyush that also iam try no change i will send file please see piyush

Amudhan Kuppan · Answer

ok piyush i will try after let you know

Amudhan Kuppan · Answer

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: -- 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

Amudhan Kuppan · Answer

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: -- 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

Piyush Pansuriya · Answer

Hi, Paste your SP to find where you are missing..

Tripat Bala Singh · Answer

Hello Amudhan Kuppan tell me you have which type of datatype of @DateOfBirth.

Amudhan Kuppan · Answer

thats also iam tried piyush but no change

Amudhan Kuppan · Answer

this is code document please see