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

HumanResources Employee (table) — 40.0%

[...] BirthDate datetime not null Date of birth. 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 = [...]

SH CUSTOMERS (table) — 25.0%

[...] first name of the customer CUST_LAST_NAME VARCHAR2(40) not null last name of the customer CUST_GENDER CHAR(1) not null gender; low cardinality attribute CUST_YEAR_OF_BIRTH NUMBER(4, 0) not null customer year of birth CUST_MARITAL_STATUS VARCHAR2(20) null customer marital status; low cardinality attribute CUST_STREET_ADDRESS VARCHAR2(40) not null customer street address CUST_POSTAL_CODE VARCHAR2(10) not null postal code of the customer CUST_CITY VARCHAR2(30) not null city where the customer lives CUST_CITY_ID NUMBER [...]

HumanResources uspUpdateEmployeePersonalInfo (procedure) — 15.0%

[...] @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] = @NationalIDNumber ,[BirthDate] = @BirthDate ,[MaritalStatus] = @MaritalStatus ,[

Sales vIndividualDemographics (view) — 10.0%

[...] namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/IndividualSurvey"; Gender[1]', 'nvarchar(1)') AS [Gender] [...]

WikiMarkup — 5.0%

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

OE CUSTOMERS (table) — 5.0%

[...] MDSYS.SDO_GEOMETRY null SDO (spatial) column. DATE_OF_BIRTH DATE(7) null MARITAL_STATUS VARCHAR2(20) null GENDER VARCHAR2(1) null INCOME_LEVEL VARCHAR2(20) [...]

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