I created a stored procedure to add a student to a school. The problem i\'m havi

Question

I created a stored procedure to add a student to a school. The problem i'm having is converting date from character string. currently using SQL 2008 server management studio and below is what i have done. ERROR MESSAGE [Conversion failed when converting date and/or time from character string.] Problem is in the [INSERT AREA]

USE [Student]

GO

/****** Object: StoredProcedure [dbo].[AddStudent] Script Date: 02/09/2017 16:05:05 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROC [dbo].[AddStudent]

AS

BEGIN

SELECT *

FROM STUDENT AS S

INNER JOIN SECTION AS C

ON S.STUDENT_ID = C.SECTION_ID

END

GO

SET IDENTITY_INSERT [STUDENT] OFF;

INSERT into dbo.STUDENT(SALUTATION,FIRST_NAME,LAST_NAME,STREET_ADDRESS,ZIP,PHONE,EMPLOYER,REGISTRATION_DATE,CREATED_BY,CREATED_DATE,

MODIFIED_BY, MODIFIED_DATE)

values('Mr.','Vicent','Johnson','1476 Big Bear','11419','678-567-0787','BOA',ISNULL ( convert (varchar(10), CURRENT_TIMESTAMP), 'None'),'Vicent',ISNULL ( convert (varchar(10), CURRENT_TIMESTAMP), 'None'),'Vicent',

ISNULL(convert (varchar(10),CURRENT_TIMESTAMP),'None'));

SET IDENTITY_INSERT [STUDENT] ON;

GO

Explanation / Answer

try replacing

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.