How to insert a value for this Table?

Question

How to insert a value for this Table? ID (PKFKintnotnull) DNumber (nvarchar(15)notnull) LoginID (nvarchar(256)notnull) OrgNode (hierarchyidnull) OrgLevel (computedsmallintnull) JobTitle (nvarchar(50)notnull) BirthDate (date notnull) MaritalStatus (nchar(1)notnull) Gender (nchar(1)notnull) HireDate (date notnull) SalariedFlag (Flag(bit)notnull) VacationHours (smallintnot null) SickLeaveHours (smallintnot null) CurrentFlag (Flag(bit)notnull) rowguid (uniqueidentifier notnull) ModifiedDate (datetimenotnull)

Upendra Pratap Shahi · Answer

insert into Table_Name(IDDNumberLoginIDOrgNodeOrgLevelJobTitleBirthDateMaritalStatusGenderHireDateSalariedFlagVacationHoursSickLeaveHoursCurrentFlagrowguidModifiedDate) values (value1........................................yourlast value) he values should be given in the order in which the column names are specified

Bhushan Bhasme · Answer

Hi deepak Ratan I suggest You To use Stored Procedure Instead Of Direct Query. It would help You for maintain the code properly.as You have many columns so SP will help you to maintain and find out the exact location of error.(i.e:exact column) without affecting the ADO.NET Code.

Upendra Pratap Shahi · Answer

Your welcome dear. Kindly accept the solution if it helped you.

Deepak Ratan · Answer

Hi Upendra Pratap Shahi Got the solution Thank you

Upendra Pratap Shahi · Answer

in your query column clause mismatched with value clause. Kindly check both the field. both are equal or not.

Sivaraman Dhamodaran · Answer

The statement has two parts. Insert into Table_Name( ColumnName1 ColumnName2.....ColumnName_N ) Values ( Value1 Value2....Value_N ) The Red one says which column you are going to insert. The green one says the value for the column. The values should be given in the order in which the column names are specified. So make sure the count of Red Entries(Column) and Green entries (values) matches.

Deepak Ratan · Answer

I am Geeting ERROR: There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement. INSERT INTO Employee (DNumberLoginIDOrgNodeOrgLevelJobTitleBirthDateMaritalStatusGenderHireDate SalaiedFlagVacationHoursSickLeaveHoursCurrentFlagrowguid ModifiedDate) Values('295847284''adventure-works\ken0''0x'0'Java''1963-03-02''S''M' '2003-02-15'199691'F01251E5-96A3-448D-981E-0F99D789110D''2008-07-31')

Sivaraman Dhamodaran · Answer

Use the below syntax: Insert into Table_Name(ColumnName1 ColumnName2.....ColumnName_N) Values (Value1 Value2....Value_N)