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 25 results.

dbo uspLogError (procedure) — 10.6%

wikibot Procedure dbo.uspLogError Description Logs error information in the ErrorLog table about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without inserting error information. Source -- uspLogError logs error information in the ErrorLog table about the -- error that caused execution to jump to the CATCH block of a -- TRY...CATCH construct. This should be executed from within the scope -- of a CATCH block otherwise it will [...]

dbo uspPrintError (procedure) — 7.4%

wikibot Procedure dbo.uspPrintError Description Prints error information about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without printing any error information. Source -- uspPrintError prints error information about the error that caused -- execution to jump to the CATCH block of a TRY...CATCH construct. -- Should be executed from within the scope of a CATCH block otherwise -- it will return without printing any error information. CREATE [...]

HumanResources uspUpdateEmployeePersonalInfo (procedure) — 5.3%

wikibot Procedure HumanResources.uspUpdateEmployeePersonalInfo Description Updates the Employee table with the values specified in the input parameters for the given EmployeeID. Source CREATE PROCEDURE [HumanResources].[uspUpdateEmployeePersonalInfo] @EmployeeID [int], @NationalIDNumber [nvarchar](15), @BirthDate [datetime], @MaritalStatus [nchar](1), @Gender [nchar](1) WITH EXECUTE AS CALLER AS BEGIN SET NOCOUNT ON; BEGIN TRY UPDATE [HumanResources].[Employee] SET [NationalIDNumber] [...]

HumanResources Employee (table) — 5.3%

[...] HumanResources.vEmployeeDepartmentHistory Select View Sales.vSalesPerson Select View Sales.vSalesPersonSalesByFiscalYears Select Procedure dbo.uspGetEmployeeManagers Select Procedure dbo.uspGetManagerEmployees Update Procedure [...]

HumanResources uspUpdateEmployeeLogin (procedure) — 5.3%

wikibot Procedure HumanResources.uspUpdateEmployeeLogin Description Updates the Employee table with the values specified in the input parameters for the given EmployeeID. Source CREATE PROCEDURE [HumanResources].[uspUpdateEmployeeLogin] @EmployeeID [int], @ManagerID [int], @LoginID [nvarchar](256), @Title [nvarchar](50), @HireDate [datetime], @CurrentFlag [dbo].[Flag] WITH EXECUTE AS CALLER AS BEGIN SET NOCOUNT ON; BEGIN TRY UPDATE [HumanResources].[Employee] SET [ManagerID] = @ManagerID [...]

HumanResources uspUpdateEmployeeHireInfo (procedure) — 5.3%

wikibot Procedure HumanResources.uspUpdateEmployeeHireInfo Description Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters. Source CREATE PROCEDURE [HumanResources].[uspUpdateEmployeeHireInfo] @EmployeeID [int], @Title [nvarchar](50), @HireDate [datetime], @RateChangeDate [datetime], @Rate [money], @PayFrequency [tinyint], @CurrentFlag [dbo].[Flag] WITH EXECUTE AS CALLER AS BEGIN SET NOCOUNT ON; BEGIN TRY [...]

dbo uspGetEmployeeManagers (procedure) — 5.3%

wikibot Procedure dbo.uspGetEmployeeManagers Description Stored procedure using a recursive query to return the direct and indirect managers of the specified [...]

dbo uspGetBillOfMaterials (procedure) — 5.3%

wikibot Procedure dbo.uspGetBillOfMaterials Description Stored procedure using a recursive query to return a multi-level bill of material for the specified [...]

dbo uspGetWhereUsedProductID (procedure) — 5.3%

wikibot Procedure dbo.uspGetWhereUsedProductID Description Stored procedure using a recursive query to return all components or assemblies that directly or indirectly use the specified [...]

dbo uspGetManagerEmployees (procedure) — 5.3%

wikibot Procedure dbo.uspGetManagerEmployees Description Stored procedure using a recursive query to return the direct and indirect employees of the specified [...]

Production WorkOrder (table) — 4.3%

[...] Production.TransactionHistory Trigger iWorkOrder Insert Table Production.TransactionHistory Trigger uWorkOrder Execute Procedure dbo.uspLogError Trigger iWorkOrder Execute Procedure dbo.uspLogError Trigger uWorkOrder Execute [...]

HR ADD_JOB_HISTORY (procedure) — 4.3%

wikibot Procedure HR.ADD_JOB_HISTORY Source CREATE OR REPLACE PROCEDURE [...]

Purchasing PurchaseOrderDetail (table) — 4.3%

[...] iPurchaseOrderDetail Update Table Purchasing.PurchaseOrderHeader Trigger uPurchaseOrderDetail Execute Procedure dbo.uspLogError Trigger iPurchaseOrderDetail Execute Procedure dbo.uspLogError Trigger uPurchaseOrderDetail Execute Procedure [...]

HumanResources (schema) — 3.2%

[...] HumanResources.vJobCandidateEducation Schema View HumanResources.vJobCandidateEmployment Schema Procedure HumanResources.uspUpdateEmployeeHireInfo Schema Procedure HumanResources.uspUpdateEmployeeLogin [...]

dbo ErrorLog (table) — 3.2%

[...] database that are caught by the CATCH block of a TRY...CATCH construct. Data is inserted by stored procedure dbo.uspLogError when it is executed from inside the CATCH block of a TRY...CATCH construct. Columns Column Data Type Nullable Default Description ErrorLogID int not null Primary key for ErrorLog records. ErrorTime datetime not null (getdate()) The date and time at which the error occurred. UserName sysname not null The user who executed the batch in which the error occurred. ErrorNumber int not null The error number of the error that occurred. [...]

Sales SalesOrderDetail (table) — 2.1%

[...] Trigger iduSalesOrderDetail Update Table Sales.SalesOrderHeader Trigger iduSalesOrderDetail Execute Procedure dbo.uspLogError Trigger iduSalesOrderDetail Execute Procedure [...]

Sales SalesOrderHeader (table) — 2.1%

[...] Trigger uSalesOrderHeader Update Table Sales.SalesTerritory Trigger uSalesOrderHeader Execute Procedure dbo.uspLogError Trigger uSalesOrderHeader Execute Procedure [...]

HR SECURE_DML (procedure) — 2.1%

wikibot Procedure HR.SECURE_DML Source CREATE OR REPLACE PROCEDURE [...]

Sales Store (table) — 2.1%

[...] Collection Sales.StoreSurveySchemaCollection Select Table Sales.Individual Trigger iStore Execute Procedure dbo.uspLogError Trigger iStore Execute Procedure [...]

Purchasing Vendor (table) — 2.1%

[...] Data Type Type dbo.Flag Data Type Type dbo.Name Schema Schema Purchasing Execute Procedure dbo.uspLogError Trigger dVendor Execute Procedure [...]

Production BillOfMaterials (table) — 2.1%

[...] Schema Schema Production Dependencies Reference Type Object Type Referencing Object Select Procedure dbo.uspGetBillOfMaterials Select Procedure [...]

Person Contact (table) — 2.1%

[...] Select View Sales.vSalesPersonSalesByFiscalYears Select View Sales.vStoreWithDemographics Select Procedure dbo.uspGetEmployeeManagers Select Procedure [...]

Production Product (table) — 2.1%

[...] Reference Type Object Type Referencing Object Select View Production.vProductAndDescription Select Procedure dbo.uspGetBillOfMaterials Select Procedure [...]

Purchasing PurchaseOrderHeader (table) — 2.1%

[...] Purchasing Update Table Purchasing.PurchaseOrderHeader Trigger uPurchaseOrderHeader Execute Procedure dbo.uspLogError Trigger uPurchaseOrderHeader Execute Procedure [...]

HumanResources EmployeePayHistory (table) — 1.1%

[...] Schema Schema HumanResources Dependencies Reference Type Object Type Referencing Object Insert Procedure HumanResources.uspUpdateEmployeeHireInfo [...]

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