TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Deepak Ratan
NA
175
50.9k
How to Create a Audit table
Jun 21 2015 11:01 PM
How to Create a Audit table for Insert, Update,Delete...?
For this Audit table how to write Trigger..?
This is my Table
Create table
Cust
CustID int PK
,PersonID int FK
,StoreID int FK
,TerritoryID int FK
,AccountNumber Computed varchar(10)
,rowguid Uniqueidentifier
,ModifiedDate datetime
Reply
Answers (
2
)
It's showing System.Data.DataRowView in SQL database
SQL Trigger for adding Old Val and New Val to audit table