How to insert a value for this Table?

Question

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)

Upendra Pratap Shahi · Answer

insert into Table_Name(ID,DNumber,LoginID,OrgNode,OrgLevel,JobTitle,BirthDate,MaritalStatus,Gender,HireDate,SalariedFlag,VacationHours,SickLeaveHours,CurrentFlag,rowguid,ModifiedDate) 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 (DNumber,LoginID,OrgNode,OrgLevel,JobTitle,BirthDate,MaritalStatus,Gender,HireDate, SalaiedFlag,VacationHours,SickLeaveHours,CurrentFlag,rowguid ,ModifiedDate) Values('295847284','adventure-works\ken0','0x',0,'Java','1963-03-02','S','M', '2003-02-15',1,99,69,1,'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)

How to insert a value for this Table?

Answers (8)