I am converting a sql server based app to access.
I was calling sql server stored procedures from a .Net application to do a time stamp.
Below are the stored procedures I was using in sql server. I'd like to be able to do the
same using access.
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[saClockIn] @EmployeeID int AS BEGIN INSERT INTO SaTimeTransactions (TransactionDate, EmployeeID, TimeIn) VALUES (convert(char(10),getdate(),121), @EmployeeID, GetDate()) End
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[saClockOut] @ID int, @Minutes int, @Hours int AS BEGIN UPDATE SaTimeTransactions SET TimeOut= getdate(), Minutes = @Minutes, Hours=@Hours WHERE ID=@ID End