Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Search Engine

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.



Filter by Category


This search, performed through 2.14 MB (338 documents, 3448 words), completed in 0.0 seconds and yielded 12 results.

Production Product (table) — 31.7%

[...] Road, M = Mountain, T = Touring, S = Standard Class nchar(2) null H = High, M = Medium, L = Low Style nchar(2) null W = Womens, M = Mens, U = Universal ProductSubcategoryID int null Product is a member of this product subcategory. Foreign key to ProductSubCategory.ProductSubCategoryID. ProductModelID int null Product is a member of this product model. Foreign key to ProductModel.ProductModelID. SellStartDate datetime not null Date the product was available for sale. SellEndDate datetime null Date the product was no longer available for sale. DiscontinuedDate [...]

WikiMarkup-Tables — 17.1%

[...] Cell 1.1 Cell 1.2 Cell 2.1 Cell 2.2 {| cellspacing="0" cellpadding="2" border="1" |- style="background-color: Red; color: White;" | Cell 1.1 || Cell 1.2 |- style="font-weight: bold;" | Cell 2.1 || Cell 2.2 |} Cell 1.1 Cell 1.2 Cell 2.1 Cell 2.2 {| | bgcolor="Blue" | Styled Cell | Normal cell |- | Normal cell | bgcolor="Yellow" | Styled cell |} Styled Cell Normal cell Normal cell Styled cell {| | colspan="2" bgcolor="Red" | Cell |- | Cell || Cell |} Cell Cell Cell {| | [...]

public setsnmpinterfacekeysoninsert (trigger function) — 7.3%

[...] 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 of the new keys -- IF NEW.snmpInterfaceId IS NULL THEN IF NEW.ifIndex IS NOT NULL THEN SELECT snmpif.id INTO NEW.snmpInterfaceId FROM snmpinterface [...]

public setifservicekeysoninsert (trigger function) — 7.3%

[...] 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 the new keys -- IF NEW.ifServiceId IS NULL THEN SELECT ifsvc.id INTO NEW.ifserviceid FROM ifservices ifsvc WHERE (ifsvc.nodeid = NEW.nodeid AND ifsvc.ipAddr [...]

public setipinterfacekeysoninsert (trigger function) — 7.3%

[...] Condition 0: ipAddr of 0.0.0.0 is not allowed in ifServices table'; END IF; -- -- (Insert with old style foreign key) -- This condition keeps the ipInterfaceId 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 of the new keys -- IF NEW.ipInterfaceId IS NULL THEN SELECT ipif.id INTO NEW.ipInterfaceId FROM ipinterface ipif WHERE (ipif.nodeid = NEW.nodeid AND ipif.ipAddr [...]

public setsnmpinterfacekeysonupdate (trigger function) — 4.9%

[...] 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 key values, the snmpInterfaceId needs to be updated -- IF ((NEW.snmpInterfaceId = OLD.snmpInterfaceId OR (NEW.snmpInterfaceId IS NULL AND OLD.snmpInterfaceId IS NULL)) AND (NEW.nodeId != OLD.nodeId [...]

public setipinterfacekeysonupdate (trigger function) — 4.9%

[...] 0.0.0.0 is not allowed in ifServices table'; END IF; -- -- (Used with Trigger Update with old style foreign key) -- This condition keeps ipinterfaceid 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 key values, the ipInterfaceId needs to be updated -- IF (NEW.ipInterfaceId = OLD.ipInterfaceId) AND (NEW.nodeId != OLD.nodeId OR NEW.ipAddr != OLD.ipAddr) THEN SELECT ipif.id INTO NEW.ipInterfaceId [...]

Production vProductModelCatalogDescription (view) — 4.9%

[...] p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription"; (/p1:ProductDescription/p1:Specifications/Style)[1]', 'nvarchar(256)') AS [Style] [...]

public setifservicekeysonupdate (trigger function) — 4.9%

[...] 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 -- IF (NEW.ifserviceID = OLD.ifServiceId) AND (NEW.nodeId != OLD.nodeId OR NEW.ipAddr != OLD.ipAddr OR NEW.serviceId != OLD.serviceID) THEN SELECT [...]

Person Contact (table) — 4.9%

[...] NameStyle dbo.NameStyle not null ((0)) 0 = The data in FirstName and LastName are stored in western style (first name, last name) order. 1 = Eastern style [...]

SnippetsAndTemplates — 2.4%

[...] parameter. In such case, its placeholder is removed from the output. Parameterized Snippets, Compact Style A compact parameterized snippet is similar [...]

WikiMarkup — 2.4%

[...] ListPrice ProductLine ReorderPoint SafetyStockLevel SellEndDate SellStartDate StandardCost Style Weight A-Za-z Bin Shelf Rating TransactionType [...]

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.