CODEWITHSUNDEEP
c#asp.netsql
WithFlyingColors
WithFlyingColors

Reputation: 2770

Problem with a sql statement

string insertCommand = 
    "INSERT INTO Users (UserID) VALUES" + "" + "(CONVERT(uniqueidentifier, '" + 
    UsersIdentityToinsert + "'),'"+ userName+",0,null')";

it tells me:

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.

But i have four columns?

Upvotes: 0

Views: 92

Answers (2)

Beno
Beno

Reputation: 4753

you only have UserID in the insert list but in the value list, you have two values - a uniqueidentifier and a username

this would work better: (assuming the name of your username column)

string insertCommand = 
    "INSERT INTO Users (UserID, username) VALUES" + "" + 
    "(CONVERT(uniqueidentifier, '" + UsersIdentityToinsert + "'),'"+ userName+"')";

EDIT:

I feel i need to address this part a bit more clearly:

But i have four columns?

The error you received refers to the number of columns specified in the INSERT statement - not the actual table so if you start an INSERT with:

INSERT INTO AnyTable (ColumnA, ColumnB)

you need to match the number of columns here in your VALUES clause

VALUES ("Value1", "Value2")

Upvotes: 2

Navaneethan
Navaneethan

Reputation: 2225

You are missing "UserName" in column Names, that is, Column Name and values mismathch.

string insertCommand = 
    "INSERT INTO Users (UserID,UserName) VALUES" + "" + 
    "(CONVERT(uniqueidentifier, '" + UsersIdentityToinsert + "'),'"+ userName+"')";

Upvotes: 0

Related Questions