I am new to SQL server and I need help with a problem I am having, I need to create a stored procedure to insert a transaction into a database I am working on. I have a transactions table already created with the following colums TransactionID int not null TransactionIDType int not null TransactionDate datetime not null CustomerID int not null InvoiceNumber int not null PaymentDueDate datetime not null Status bit not null
I know how to start to create a stored procedure but I don't know how to get it to insert a transaction into the table
what I am doing is I am creating a database for a company, and I need a stored procedure to get the information from a transaction and insert that information into the Transactions table
what I am doing is I am creating a database for a company, and I need a stored procedure to get the information from a transaction and insert that information into the Transactions table
Well, that's what I gather...sounds like what you want is to capture a DML operation against a table, in which case you want a trigger to fire and place the "transaction" into a transaction, or history table
Help please
Posted - 01/16/2007 : 13:10:44
