How to insert a value for this Table?

Jun 19 2015 5:32 AM

How to insert a value for this Table?

ID (PK,FK,int,notnull)

DNumber (nvarchar(15),notnull)

LoginID (nvarchar(256),notnull)

OrgNode (hierarchyid,null)

OrgLevel (computed,smallint,null)

JobTitle (nvarchar(50),notnull)

BirthDate (date, notnull)

MaritalStatus (nchar(1),notnull)

Gender (nchar(1),notnull)

HireDate (date, notnull)

SalariedFlag (Flag(bit),notnull)

VacationHours (smallint,not null)

SickLeaveHours (smallint,not null)

CurrentFlag (Flag(bit),notnull)

rowguid (uniqueidentifier, notnull)

ModifiedDate (datetime,notnull)

Answers (8)

programmatically add 30 rows whit date