Skip to content
  • Home
  • About
  • No Access
  • Privacy Policy
Bits of .NET
Bits of .NET
  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy

Bits of .NET

Daily micro-tips for C#, SQL, performance, and scalable backend engineering.

  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy
SQL

SQL Server: Fix a Column Default Value That Doesn’t Apply to Rows Inserted by the App

- 06.09.26 - ErcanOPAK

🗄️ Your Column Has a Default Value – and the App’s Inserted Rows Don’t Get It

A column is given a `DEFAULT` constraint specifically so new rows automatically get a sensible value without every INSERT having to specify it – and rows inserted by the application keep showing NULL (or 0) instead, because a column default ONLY applies when a column is OMITTED from the INSERT statement entirely; an ORM or query that explicitly includes the column with a null/default value in code bypasses the database default completely.

🔎 The Problem

ALTER TABLE Orders
ADD CreatedDate DATETIME DEFAULT GETDATE();

-- The default only applies when CreatedDate is OMITTED from the
-- column list entirely:
INSERT INTO Orders (CustomerId, Total) VALUES (1, 99.99);
-- CreatedDate correctly gets GETDATE() here.

-- But most ORMs generate INSERT statements that list EVERY mapped
-- property explicitly - including CreatedDate with whatever value the
-- C# object had (often null/default(DateTime)) at the moment of
-- insert:
INSERT INTO Orders (CustomerId, Total, CreatedDate) VALUES (1, 99.99, NULL);
-- The column default is bypassed entirely - NULL is what actually gets
-- stored, because the column WAS specified, just with a null value.

✅ Fix: Decide Where the Default Actually Belongs

  • If the value should always come from the database (server-side timestamp, a computed default), configure the ORM/entity mapping to EXCLUDE that column from INSERT statements entirely (e.g., EF Core’s `ValueGeneratedOnAdd()` combined with the property not being set in code) so the database default actually gets a chance to apply.
  • Alternatively, set the value explicitly in application code at the moment of insert (`CreatedDate = DateTime.UtcNow`) and treat the database DEFAULT purely as a safety net for INSERTs that come from OUTSIDE the app (manual scripts, other systems) rather than relying on it for the app’s own normal path.

⚠️ How to Confirm This Is What’s Happening

  • Turn on SQL query logging for the ORM (EF Core’s `LogTo` / sensitive data logging, or SQL Profiler/Extended Events) and look at the actual generated INSERT statement – if the column appears explicitly in the column list, the default is being bypassed regardless of what the constraint says.

A column default is a promise for what happens when you say nothing – the moment your INSERT says something, even NULL, that promise doesn’t apply anymore.

— Database Engineer

Related posts:

SQL: Use Foreign Keys for Data Relationships

SQL: Use Foreign Keys for Data Relationships

Why NVARCHAR(MAX) Can Destroy Query Plans

Why NVARCHAR(MAX) Can Destroy Query Plans

SQL: Use CROSS APPLY for Correlated Subqueries Performance

SQL: Use CROSS APPLY for Correlated Subqueries Performance

Views: 16

Post navigation

SQL Server: Why NULL Values Break a Simple NOT IN Subquery
The AI Prompt That Reviews a Privacy Policy for What Data It Actually Collects

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

November 2026
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
30  
« Oct    

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,055)
  • Get the User Name and Domain Name from an Email Address in SQL (980)
  • How to add default value for Entity Framework migrations for DateTime and Bool (976)
  • Get the First and Last Word from a String or Sentence in SQL (857)
  • How to select distinct rows in a datatable in C# (852)
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server (653)
  • Add Constraint to SQL Table to ensure email contains @ (607)
  • Average of all values in a column that are not zero in SQL (569)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (546)
  • Find numbers with more than two decimal places in SQL (475)

Recent Posts

  • C#: Fix a ConditionalWeakTable Entry Vanishing Too Soon
  • Docker: Fix a Stale COPY Layer After Editing .dockerignore
  • Photoshop: Fix a Pattern Overlay Scaling Wrong on a High-DPI File
  • SQL Server: Fix a Computed Column Index Skipped by Implicit Cast
  • HTML5: Fix a required Input Inside a Hidden Tab Blocking Submit
  • SQL Server: Fix ROW_NUMBER Ties Reordering Between Identical Runs
  • C#: Fix an Enum HasFlag Returning True for the Zero Value
  • WordPress: Fix Featured Images Vanishing After a CDN Migration
  • Photoshop: Fix Content-Aware Fill Smearing a Repeating Pattern
  • Asp.Net Core: Fix Antiforgery Tokens Rejected Behind a Reverse Proxy

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,055)
  • Get the User Name and Domain Name from an Email Address in SQL (980)
  • How to add default value for Entity Framework migrations for DateTime and Bool (976)
  • Get the First and Last Word from a String or Sentence in SQL (857)
  • How to select distinct rows in a datatable in C# (852)

Recent Posts

  • C#: Fix a ConditionalWeakTable Entry Vanishing Too Soon
  • Docker: Fix a Stale COPY Layer After Editing .dockerignore
  • Photoshop: Fix a Pattern Overlay Scaling Wrong on a High-DPI File
  • SQL Server: Fix a Computed Column Index Skipped by Implicit Cast
  • HTML5: Fix a required Input Inside a Hidden Tab Blocking Submit

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter
© 2026 Bits of .NET | Built with Xblog Plus free WordPress theme by wpthemespace.com