Here you can search through the pages of this Namespace, their attachments and the files uploaded to the system.
Note: the results will only display the items you have permissions to read.
[...] wikibot
Table public.qrtz_triggers Columns Column Data Type Nullable Default Description trigger_name varchar(80) not null trigger_group varchar(80) not null job_name varchar(80) not null job_group varchar(80) not null is_volatile boolean not null description varchar(120) null next_fire_time bigint null prev_fire_time bigint null trigger_state varchar(16) not null trigger_type varchar(8) not null start_time bigint not null end_time [...]
[...] ProductID ProductID Purchasing.PurchaseOrderHeader PurchaseOrderID PurchaseOrderID Triggers Trigger Type iPurchaseOrderDetail ON INSERT uPurchaseOrderDetail ON UPDATE Trigger iPurchaseOrderDetail
CREATE TRIGGER [Purchasing].[iPurchaseOrderDetail] ON [Purchasing].[PurchaseOrderDetail]
AFTER INSERT AS
BEGIN
DECLARE @Count int;
SET @Count = @@ROWCOUNT;
IF @Count = 0
RETURN;
SET NOCOUNT ON;
BEGIN TRY
INSERT INTO [Production].[TransactionHistory]
([ProductID]
[...]
[...] SalesOrderID SalesOrderID Sales.SalesOrderHeaderSalesReason SalesOrderID SalesOrderID Triggers Trigger Type uSalesOrderHeader ON UPDATE Trigger uSalesOrderHeader
CREATE TRIGGER [Sales].[uSalesOrderHeader] ON [Sales].[SalesOrderHeader]
AFTER UPDATE NOT FOR REPLICATION AS
BEGIN
DECLARE @Count int;
SET @Count = @@ROWCOUNT;
IF @Count = 0
RETURN;
SET NOCOUNT ON;
BEGIN TRY
-- Update RevisionNumber for modification of any field EXCEPT the Status.
IF NOT UPDATE([Status])
[...]
[...] SalesOrderID SalesOrderID Sales.SpecialOfferProduct SpecialOfferID SpecialOfferID Triggers Trigger Type iduSalesOrderDetail ON INSERT UPDATE DELETE Trigger iduSalesOrderDetail
CREATE TRIGGER [Sales].[iduSalesOrderDetail] ON [Sales].[SalesOrderDetail]
AFTER INSERT, DELETE, UPDATE AS
BEGIN
DECLARE @Count int;
SET @Count = @@ROWCOUNT;
IF @Count = 0
RETURN;
SET NOCOUNT ON;
BEGIN TRY
-- If inserting or updating these columns
IF UPDATE([ProductID]) OR UPDATE([OrderQty]) [...]
wikibot
Table public.qrtz_trigger_listeners Columns Column Data Type Nullable Default Description trigger_name varchar(80) not null trigger_group [...]
[...] Table Column Referencing Column Production.WorkOrderRouting WorkOrderID WorkOrderID Triggers Trigger Type iWorkOrder ON INSERT uWorkOrder ON UPDATE Trigger iWorkOrder
CREATE TRIGGER [Production].[iWorkOrder] ON [Production].[WorkOrder]
AFTER INSERT AS
BEGIN
DECLARE @Count int;
SET @Count = @@ROWCOUNT;
IF @Count = 0
RETURN;
SET NOCOUNT ON;
BEGIN TRY
INSERT INTO [Production].[TransactionHistory](
[ProductID]
,[ReferenceOrderID]
,[TransactionType]
[...]
[...] Referencing Column Purchasing.PurchaseOrderDetail PurchaseOrderID PurchaseOrderID Triggers Trigger Type uPurchaseOrderHeader ON UPDATE Trigger uPurchaseOrderHeader
CREATE TRIGGER [Purchasing].[uPurchaseOrderHeader] ON [Purchasing].[PurchaseOrderHeader]
AFTER UPDATE AS
BEGIN
DECLARE @Count int;
SET @Count = @@ROWCOUNT;
IF @Count = 0
RETURN;
SET NOCOUNT ON;
BEGIN TRY
-- Update RevisionNumber for modification of any field EXCEPT the Status.
IF NOT UPDATE([Status])
[...]
wikibot
Trigger Function public.setipinterfacekeysonupdate Source
CREATE OR REPLACE FUNCTION public.setipinterfacekeysonupdate()
RETURNS trigger
LANGUAGE plpgsql
AS $function$
BEGIN
-- ifServices must have an IP address that is *not* 0.0.0.0
IF NEW.ipAddr IS NOT NULL AND NEW.ipAddr = '0.0.0.0'
THEN
RAISE EXCEPTION 'IfServices Trigger Exception, Condition 0: ipAddr of 0.0.0.0 is not allowed in ifServices table';
END IF;
--
-- (Used with Trigger Update [...]
[...] Execute Procedure HumanResources.uspUpdateEmployeePersonalInfo Execute Table Production.WorkOrder Trigger iWorkOrder Execute Table Production.WorkOrder Trigger uWorkOrder Execute Table Purchasing.PurchaseOrderDetail Trigger iPurchaseOrderDetail Execute Table Purchasing.PurchaseOrderDetail Trigger uPurchaseOrderDetail Execute Table Purchasing.PurchaseOrderHeader [...]
[...] Child Type Child Object Execute Procedure dbo.uspLogError Execute Table Production.WorkOrder Trigger iWorkOrder Execute Table Production.WorkOrder Trigger uWorkOrder Execute Table Purchasing.PurchaseOrderDetail Trigger iPurchaseOrderDetail Execute Table Purchasing.PurchaseOrderDetail Trigger uPurchaseOrderDetail Execute Table Purchasing.PurchaseOrderHeader [...]
[...] Referenced Column Person.Contact ContactID ContactID Sales.Customer CustomerID CustomerID Triggers Trigger Type iuIndividual ON INSERT UPDATE Trigger iuIndividual
CREATE TRIGGER [Sales].[iuIndividual] ON [Sales].[Individual]
AFTER INSERT, UPDATE NOT FOR REPLICATION AS
BEGIN
DECLARE @Count int;
SET @Count = @@ROWCOUNT;
IF @Count = 0
RETURN;
SET NOCOUNT ON;
-- Only allow the Customer to be a Store OR Individual
IF EXISTS (SELECT * FROM inserted INNER JOIN [Sales].[Store] [...]
wikibot
Trigger Function public.setipinterfacekeysoninsert Source
CREATE OR REPLACE FUNCTION public.setipinterfacekeysoninsert()
RETURNS trigger
LANGUAGE plpgsql
AS $function$
BEGIN
-- ifServices must have an IP address that is *not* 0.0.0.0
IF NEW.ipAddr IS NOT NULL AND NEW.ipAddr = '0.0.0.0'
THEN
RAISE EXCEPTION 'IfServices Trigger Exception, Condition 0: ipAddr of 0.0.0.0 is not allowed in ifServices table';
END IF;
--
-- (Insert with old style foreign key)
-- This condition [...]
wikibot
Trigger Function public.setifservicekeysoninsert Source
CREATE OR REPLACE FUNCTION public.setifservicekeysoninsert()
RETURNS trigger
LANGUAGE plpgsql
AS $function$
BEGIN
--
-- (Used with Trigger Insert with old style foreign key)
-- This condition keeps the ifServiceID inSync with the composite foreign key of nodeid, ipaddr, serviceid
-- This usually happens when a new record is written by our JDBC code (non-Hibernate DAO) for the old JDBC style
-- code has no knowledge of [...]
wikibot
Trigger Function public.setsnmpinterfacekeysonupdate Source
CREATE OR REPLACE FUNCTION public.setsnmpinterfacekeysonupdate()
RETURNS trigger
LANGUAGE plpgsql
AS $function$
BEGIN
--
-- (Used for Trigger update with old style foreign key)
-- This condition keeps snmpinterfaceid inSync with the composite foreign key of nodeid, ipaddr, ifindex
-- This usually happens when a record is being updated by old JDBC code (non-Hibernate DAOs) and has changed
-- one or more of the composite [...]
[...] Detail Table Column Referencing Column Sales.StoreContact CustomerID CustomerID Triggers Trigger Type iStore ON INSERT Trigger iStore
CREATE TRIGGER [Sales].[iStore] ON [Sales].[Store]
AFTER INSERT AS
BEGIN
DECLARE @Count int;
SET @Count = @@ROWCOUNT;
IF @Count = 0
RETURN;
SET NOCOUNT ON;
BEGIN TRY
-- Only allow the Customer to be a Store OR Individual
IF EXISTS (SELECT * FROM inserted INNER JOIN [Sales].[Individual]
ON inserted.[CustomerID] [...]
wikibot
Trigger Function public.setsnmpinterfacekeysoninsert Source
CREATE OR REPLACE FUNCTION public.setsnmpinterfacekeysoninsert()
RETURNS trigger
LANGUAGE plpgsql
AS $function$
BEGIN
--
-- (Used for Trigger insert with old style foreign key)
-- This condition keeps the snmpInterfaceId inSync with the composite foreign key of nodeid, ipaddr, ifindex
-- This usually happens when a new record is written by our JDBC code (non-Hibernate DAO) for the old JDBC style
-- code has no knowledge [...]
[...]
Table public.qrtz_cron_triggers Columns Column Data Type Nullable Default Description trigger_name varchar(80) not null trigger_group varchar(80) not null cron_expression varchar(80) not null time_zone_id varchar(80) null Primary Key Primary Key Columns pk_qrtz_cron_triggers [...]
[...]
Table public.qrtz_blob_triggers Columns Column Data Type Nullable Default Description trigger_name varchar(80) not null trigger_group varchar(80) not null blob_data bytea null Primary Key Primary Key Columns pk_qrtz_blob_triggers [...]
wikibot
Trigger Function public.setifservicekeysonupdate Source
CREATE OR REPLACE FUNCTION public.setifservicekeysonupdate()
RETURNS trigger
LANGUAGE plpgsql
AS $function$
BEGIN
--
-- (Update with old style foreign key)
-- This condition keeps ifserviceid inSync with the composite foreign key of nodeid, ipaddr, serviceid
-- This usually happens when a record is being updated by old JDBC code (non-Hibernate DAOs) and has changed
-- one or more of the composite key values, the ifServiceId needs to be updated
--
[...]
[...] Table public.qrtz_simple_triggers Columns Column Data Type Nullable Default Description trigger_name varchar(80) not null trigger_group varchar(80) not null repeat_count bigint not null repeat_interval bigint not null times_triggered bigint not null Primary Key Primary Key Columns pk_qrtz_simple_triggers [...]
wikibot
Table public.qrtz_paused_trigger_grps Columns Column Data Type Nullable Default Description trigger_group varchar(80) not null [...]
wikibot
Database Trigger ddlDatabaseTriggerLog Description Database trigger to audit all of the DDL changes made to the AdventureWorks [...]
[...] Type Object Type Referencing Object Child Type Child Object Insert Table Production.WorkOrder Trigger iWorkOrder Insert Table Production.WorkOrder Trigger uWorkOrder Insert Table Purchasing.PurchaseOrderDetail Trigger iPurchaseOrderDetail [...]
[...] Purchasing.VendorAddress VendorID VendorID Purchasing.VendorContact VendorID VendorID Triggers Trigger Type dVendor INSTEAD OF DELETE Trigger dVendor
CREATE TRIGGER [Purchasing].[dVendor] ON [Purchasing].[Vendor]
INSTEAD OF DELETE NOT FOR REPLICATION AS
BEGIN
DECLARE @Count int;
SET @Count = @@ROWCOUNT;
IF @Count = 0
RETURN;
SET NOCOUNT ON;
BEGIN TRY
DECLARE @DeleteCount int;
SELECT @DeleteCount = COUNT(*) FROM deleted;
IF @DeleteCount > 0
BEGIN
[...]
[...] Purchasing.PurchaseOrderHeader EmployeeID EmployeeID Sales.SalesPerson EmployeeID SalesPersonID Triggers Trigger Type dEmployee INSTEAD OF DELETE Trigger [...]
[...] table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog. Columns Column Data Type Nullable Default Description DatabaseLogID int not null Primary key for DatabaseLog records. PostTime datetime not null The date and time the DDL change occurred. DatabaseUser sysname not null The user who implemented the DDL change. Event sysname not null The type of DDL statement that was executed. Schema sysname null The schema to which the changed object belongs. Object sysname null [...]
[...] qrtz_job_details (public)
qrtz_job_listeners (public)
qrtz_locks (public)
qrtz_paused_trigger_grps (public)
qrtz_scheduler_state (public)
qrtz_simple_triggers (public)
qrtz_trigger_listeners (public)
qrtz_triggers (public)
reportlocator (public)
resourcereference (public)
servermap (public)
service (public)
servicemap (public)
snmpinterface (public)
statisticsreport (public)
statisticsreportdata (public)
stpinterface (public)
stpnode (public)
testdatatypes [...]
[...] Function dbo.ufnGetAccountingEndDate Description Scalar function used in the uSalesOrderHeader trigger to set the starting account date. Source
CREATE FUNCTION [dbo].[ufnGetAccountingEndDate]()
RETURNS [datetime]
AS
BEGIN
RETURN DATEADD(millisecond, -2, CONVERT(datetime, '20040701', 112));
END;
Dependencies Reference Type Object Type Referencing Object Child Type Child Object Execute Table Sales.SalesOrderHeader Trigger [...]
[...] public.qrtz_fired_triggers Columns Column Data Type Nullable Default Description entry_id varchar(95) not null trigger_name varchar(80) not null trigger_group [...]
[...] Function dbo.ufnGetAccountingStartDate Description Scalar function used in the uSalesOrderHeader trigger to set the ending account date. Source
CREATE FUNCTION [dbo].[ufnGetAccountingStartDate]()
RETURNS [datetime]
AS
BEGIN
RETURN CONVERT(datetime, '20030701', 112);
END;
Dependencies Reference Type Object Type Referencing Object Child Type Child Object Execute Table Sales.SalesOrderHeader Trigger [...]