I've created this table but when I execute the procedure
It tells me there is an error on in date
CREATE TABLE [dbo].[Customers](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50)NOT NULL,
[Place _Of_ Brith] [nvarchar](50)NOT NULL,
[Date _Of _Brith] [date]NOT NULL,
[Address] [nvarchar](50)NOT NULL,
[Phone] [varchar](15) NULL,
CONSTRAINT [PK_Customer] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
USE [ahmed-h]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[sproc_insertCustomer]
@Name = N'alan',
@Place_Of_Brith = N'dama',
@Date_Of_Brith = 1987/14/10,
@Address = N'kh-sama',
@Phone = N'5487965985'
SELECT 'Return Value' = @return_value
GO
the error
Msg 102, Level 15, State 1, Line 7
Incorrect syntax near '/'.