title: How to insert value in Foreign Key column?
body: <p>How <code>Foreign Key</code> column will be filled in the following scenario.</p>
  
  <p>it is returning <code>NULL</code> value in <code>tblCustomer</code>'s <code>OrderId</code> column, whereas it is set to foreign constraint. </p>
  
  <pre><code>create table tblOrder
  (
  OrderId int primary key identity(1,1),
  OrderName varchar(20) not null
  )
  create table tblCustomer
  (
  CustomerId int primary key identity(1,1),
  CustomerName varchar(20) not null,
  OrderId int FOREIGN KEY REFERENCES tblOrder(OrderId)
  )
  
  insert into tblOrder(OrderName) Values ('OrderOne')
  insert into tblCustomer(CustomerName) values ('CustomerOne')
  </code></pre>
  
  <p>How it will get the foreign key result to store in column. </p>