You can use T-SQL to return a list of trigger events in a database in SQL Server.
You can do this using sys.trigger_events. This system catalog view returns a row for each event or event group on which a trigger can fire.
Tag: t-sql
Hierarchical List of Trigger Event Types in SQL Server 2019
Here’s a hierarchical list of trigger event types that are returned in my SQL Server 2019 for Linux environment.
This list was created using this query.
Hierarchical List of Trigger Event Types in SQL Server 2017
Here’s a hierarchical list of trigger event types that are returned in my SQL Server 2017 for Linux environment.
This list was created using this query.
Query that Returns a Hierarchical List of Trigger Event Types in SQL Server
In SQL Server, you can use the following T-SQL queries to return a hierarchical list of trigger event types.
These examples query the sys.trigger_event_types view, which returns a row for each event or event group on which a trigger can fire.
Use sys.trigger_event_types to List Trigger Event Types in SQL Server
In SQL Server, you can use sys.trigger_event_types to return all events or event groups on which a trigger can fire.
Use CRYPT_GEN_RANDOM() to Create a Cryptographic, Random Number in SQL Server
In SQL Server, you can use the CRYPT_GEN_RANDOM() function to return a cryptographic, randomly-generated number. The number is generated by the Cryptographic Application Programming Interface (CAPI).
CAPI is a Microsoft Windows platform specific application programming interface included with Microsoft Windows operating systems that provides services to enable developers to secure Windows-based applications using cryptography.
The CRYPT_GEN_RANDOM() function accepts two arguments: the length (required), and a seed (optional).
The return value is varbinary(8000).
4 Ways to List All Views in a SQL Server Database
This article presents four ways to return a list of user-defined views in a SQL Server database.
If you want to see only system views, or both user-defined and system views, see Difference Between sys.views, sys.system_views, & sys.all_views in SQL Server.
2 Ways to Return a List of Triggers in a SQL Server Database using T-SQL
If you prefer to administer your SQL Server databases by running T-SQL queries, instead of using the GUI, here are two options for listing all triggers in the current database.
2 Ways to Return All User-Defined Functions in a SQL Server Database
This article presents two ways to return a list of user-defined functions in a SQL Server database.
Return the Base Data Type from a SQL_Variant Value in SQL Server
In SQL Server, you can use the SQL_VARIANT_PROPERTY() function to return base data type information from a sql_variant value.
The function accepts two arguments: the sql_variant value, and the property for which information is to be provided.