March 19, 2004 at 2:48 am
Hi to everyone who uses this site this is my first posting.
I have a database on SQL Server 2000. What I need to do is to call upon today's date and be able to insert this into a table.
The SQL Database is linked with a bespoke front end system.
As an example, I have created a table named CM_Conveyancing and there is a field within this table named DateInstructionsReceived (which is always today). I want to use the front end so that when the user runs a workflow (series of events which user works through and answers questions which write back to the database) instead of the user being asked to enter today's date, this could be automated.
I was thinking of using a View or a Stored Proceedure but am unsure where to start as my knowledge is pretty basic.
If there is anyone who could help I would appreciate it, thankyou
Lisa,
Manchester, England
March 19, 2004 at 3:02 am
GetDate() if the function in T-SQL to return Now value.
You can use default to get value inserted into table without mention the column name.
For detail information, check BOL (book online) in sql.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply