I have the following storedprocedure in a sql express database
ALTER PROCEDURE [dbo].[FillRunLog]
-- Add the parameters for the stored procedure here
@RunNo int = 0,
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
insert into RunLog(RunNo,Rundate)
i want to call this SP from code using a Command
Cmd.CommandText = "FillRunLog " & 5 & ", '" & Now & "'"
this should fill 5 into RunNo and current date and time into RunDate
now has the valuse #2/21/2006 12:50:43 PM# which is the 21st of Feb. Which is correct.
I am pretty sure I am getting an error because it is trying to save this as the 2nd day of the 21st month which is american format.
How can get it to save the way I want.