In a requirenment i have a table of name
UserOrganisationInfo with columns of
-->OrgId(bigint PK,identity(1,1))
-->UserId int
-->OrgTypeID int (FOREIGN KEY)
-->Country Id int (FOREIGN KEY)
-->State ID int (FGOREIGN KEY)
-->OrganisationName nvarchar(100)
-->OrganisationLogo nvarchar(max)
-->OrganizationSize bigint
-->City nvarchar(max)
-->Address1 nvarchar(max)
-->Address2 nvarchar(max)
-->Zipcode nvarchar(max)
-->Website nvarchar(max)
-->CreatedOn datetime
-->UpdatedOn datetime
-->Status int
-->OrgDescription nvarchar(max)
In my store procedure i had written all the parameters except for FOREIGN KEY fields...becoz those are belongs to other table..but i am getting the below error...and my store procedure is below..
create procedure USP_UserOrganizationInfo(
@UserId bigint=null,
@OrganisationName nvarchar(100)=null,
@OrganisationLogo nvarchar(max)=null,
@OrganizationSize bigint=null,
@City nvarchar(max)=null,
@Address1 nvarchar(max)=null,
@Address2 nvarchar(max)=null,
@Zipcode nvarchar(max)=null,
@Website nvarchar(max)=null,
@CreatedOn datetime=null,
@UpdatedOn datetime=null,
@Status int=null,
@OrgDescription nvarchar(max)=null
)
as
begin
set nocount on
insert into UserOrganizationInfo values(
@OrganisationName,
@OrganisationLogo,
@OrganizationSize,
@City,
@Address1,
@Address2,
@Zipcode,
@Website,
@CreatedOn,
@UpdatedOn,
@Status,
@OrgDescription)
end
error is-->Column name or number of supplied values does not match table definition.
how do i insert the values of my table except for foreign key fields...any sugestions or advices are broadly accepted.....:)...:)