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

HumanResources Employee (table) — 46.2%

[...] MaritalStatus nchar(1) not null M = Married, S = Single Gender nchar(1) not null M = Male, F = Female HireDate datetime not null Employee hired on this date. SalariedFlag dbo.Flag not null ((1)) Job classification. 0 = Hourly, not exempt from collective bargaining. 1 = Salaried, exempt from collective bargaining. VacationHours smallint not null ((0)) Number of available vacation hours. SickLeaveHours smallint not null ((0)) Number of available sick leave hours. CurrentFlag dbo.Flag not null ((1)) 0 = Inactive, 1 = Active rowguid uniqueidentifier not null (newid()) [...]

HumanResources uspUpdateEmployeeLogin (procedure) — 23.1%

[...] @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 ,[LoginID] = @LoginID ,[Title] = @Title ,[HireDate] [...]

HumanResources uspUpdateEmployeeHireInfo (procedure) — 23.1%

[...] [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 BEGIN TRANSACTION; UPDATE [HumanResources].[Employee] SET [Title] = @Title ,[HireDate] [...]

WikiMarkup — 7.7%

[...] {Orphans} List of pages that have no incoming links {Wanted} BirthDate Gender HireDate MaritalStatus SickLeaveHours VacationHours [...]

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