Loading

How to insert a value for this Table?

How to insert a value for this Table?

Deepak Ratan

Deepak Ratan

11y1.2kSQL

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)

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Upendra Pratap Shahi11y ago
Accepted 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
+1
Bhushan Bhasme11y ago
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.
0
Upendra Pratap Shahi11y ago
Your welcome dear.

Kindly accept the solution if it helped you.
0
Deepak Ratan11y ago
Hi Upendra Pratap Shahi
Got the solution, Thank you
0
Upendra Pratap Shahi11y ago
in your query column clause mismatched with value clause. Kindly check both the field.
both are equal or not.
0
Sivaraman Dhamodaran11y ago
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.
0
Deepak Ratan11y ago
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')
0
Sivaraman Dhamodaran11y ago
Use the below syntax:
Insert into Table_Name(ColumnName1, ColumnName2.....ColumnName_N) Values (Value1, Value2,....Value_N)
0