Thanks for your replay..
My requirement is if any record in any table deleted from via application then I need to cature that record in some where for future reference. I just given example one table strucure like this but idea is I Plan to create one
new table called "deletedrecords" with Field Name called "SerialNo","TableName","DeletedRecord","CreatedDate","CreatedBy"
Whenever end user click the delete button then immediatly it will give "Table Name" and "Key ID" of the table as input to my SP's . Then I have to Take that record and store it into above table and then delete the record
in the actual table.
So I belive there are lot of query export are here defenitly any one can help me for the same.
1. I have a Table Name and a Primary Key value of the Table
2. Using the Table Name, I can get the Column Name from sys.syscolumns table.
3. Using Key ID and Table name , I can get the a record from that table
4. I don't Know how to contact fieldname and value as I mentioned above?
Please any one help me for the same.
commented on Oct 30 2010 6:42PM