Link Details

Link 1136859 thumbnail
User 1049989 avatar

By indiana_joy
via sqlknowledgebank.blogspot.in
Submitted: Apr 07 2014 / 06:36

Introduction From MS SQL Server 2005, we can get data regarding the event that initiated the DDL trigger by accessing the EventData()function. How it’s Works The main tasks of the function named EventData() is to return the information about the Server or Database Event and stored in a variable with data type XML. We just capture the data return by EventData() function and store it to a Table object for showing report. If needed we can store the data to directly a XML data type holder columns of a table or process the data and store it to the different columns according to needs. As the return type of the function named EventData() is in XML format , we can apply XQuery against it. To understand it properly let’s take an example
  • 1
  • 0
  • 137
  • 14

Add your comment


Html tags not supported. Reply is editable for 5 minutes. Use [code lang="java|ruby|sql|css|xml"][/code] to post code snippets.

Voters For This Link (1)



Voters Against This Link (0)



    Java Performance Optimization
    Written by: Pierre-Hugues Charbonneau
    Featured Refcardz: Top Refcardz:
    1. Design Patterns
    2. OO JS
    3. Cont. Delivery
    4. Java EE7
    5. HTML5 Mobile
    1. Node.js
    2. Debugging JavaScript
    3. OO JS
    4. JSON
    5. Ajax