مشكلة التاريخ في Stored Procedure.

عندي قاعدة بيانات استخدم البروسيجير لعملية التحديث وهذا الكود

CREATE PROCEDURE [update_Employee_1]
	(@Employee_ID_1 	[int],
	 @Employee_ID_2 	[int],
	 @Employee_Name_E_3 	[nvarchar](50),
	 @Employee_Name_A_4 	[nvarchar](50),
	 @Department_5 	[nvarchar](50),
	 @Resigned_6 	[nvarchar](50),
	 @Date_Of_Resignation_7 	[datetime],
	 @Photo_8 	[image],
	 @Birth_Day_9 	[datetime],
	 @Jobtitle_10 	[nvarchar](50),
	 @Date_Of_Appointment_11 	[datetime],
	 @Nationality_12 	[nvarchar](50),
	 @Bank_13 	[nvarchar](50),
	 @Bank_Account_Number_14 	[int],
	 @Bank_Branch_15 	[nvarchar](50),
	 @Mobile_16 	[int])

AS UPDATE [Salary].[dbo].[Employee] 

SET  [Employee_ID]	 = @Employee_ID_2,
	 [Employee_Name_E]	 = @Employee_Name_E_3,
	 [Employee_Name_A]	 = @Employee_Name_A_4,
	 [Department]	 = @Department_5,
	 [Resigned]	 = @Resigned_6,
	 [Date_Of_Resignation]	 = @Date_Of_Resignation_7,
	 [Photo]	 = @Photo_8,
	 [Birth_Day]	 = @Birth_Day_9,
	 [Jobtitle]	 = @Jobtitle_10,
	 [Date_Of_Appointment]	 = @Date_Of_Appointment_11,
	 [Nationality]	 = @Nationality_12,
	 [Bank]	 = @Bank_13,
	 [Bank_Account_Number]	 = @Bank_Account_Number_14,
	 [Bank_Branch]	 = @Bank_Branch_15,
	 [Mobile]	 = @Mobile_16 

WHERE 
	( [Employee_ID]	 = @Employee_ID_1)
GO

عند ما اعمل تحديث لحقل يعطيني الخطاؤ التالي

Server: Msg 8114, Level 16, State 4, Procedure update_Employee_1, Line 0
Error converting data type varchar to datetime.

واستخدم الجملة التالية في Query Analuzer:

Update_employee_1'12345','123456','Employee_Name_E','Employee_Name_A','Department','Resigned','0/0/1900','','13/4/1982','Nationality','Bank','Bank_Account_Number','Bank_Branch','00000','sharga','050827'

مشكلة التاريخ في Stored Procedure.

مواضيع مشابهة

عدد الزوار حالياً