Home » SQL & PL/SQL » SQL & PL/SQL » Excute procedure
Excute procedure [message #609649] Mon, 10 March 2014 19:28 Go to next message
man silence
Messages: 34
Registered: March 2013
Member
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 '/'.
Re: Excute procedure [message #609650 is a reply to message #609649] Mon, 10 March 2014 19:40 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post complete results from the following SQL

SELECT * FROM V$VERSION;

Re: Excute procedure [message #609651 is a reply to message #609650] Mon, 10 March 2014 19:53 Go to previous messageGo to next message
man silence
Messages: 34
Registered: March 2013
Member
No More Results
Maybe, because I use it in (SQL Express Server 2008)
What can I do ?
Re: Excute procedure [message #609652 is a reply to message #609651] Mon, 10 March 2014 19:55 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Maybe, because I use it in (SQL Express Server 2008)
>What can I do ?

Find a forum for your database.
This forum is only for Oracle database!
Re: Excute procedure [message #609653 is a reply to message #609652] Mon, 10 March 2014 19:58 Go to previous message
man silence
Messages: 34
Registered: March 2013
Member
Sorry
Thanks alot
Previous Topic: 01843. 00000 - "not a valid month"
Next Topic: How I can increase size of message UTL_MAIL I need to send more than 10,000 characters
Goto Forum:
  


Current Time: Thu Apr 25 13:07:27 CDT 2024