Incorrect syntax near '/'.
ALTER PROCEDURE [dbo].[main_Escort_Insert]
-- Add the parameters for the stored procedure here
@EscortID int,
@FirstName varchar(50),
@Surname varchar(50),
@CrbCheck bit = 0,
@CrbRef bit = false,
@ExpiryDate dateTime = null,
@Training bit = false,
@TrainingType bit = false
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
DECLARE @Escort int
-- Insert statements for procedure here
Insert Into tb_Escorts (EscortID, FirstName,Surname, [CRB_Check], [CRB_Ref],ExpiryDate, Training, TrainingType)
VALUES(@EscortID,@FirstName,@Surname,@CrbCheck,@CrbRef,@ExpiryDate,@Training,@TrainingType)
Any advice when i execute i enter the following for the ExpiryDate as follow
@ExpiryDate =31/01/2015,
Msg 102, Level 15, State 1, Line 10
Incorrect syntax near '/'.
I'm using SQL 2012
any idea what format should i use to insert a date when executing the sproc from the SQL Studio Management
thank you in advance