惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

Google DeepMind News
Google DeepMind News
S
Secure Thoughts
Application and Cybersecurity Blog
Application and Cybersecurity Blog
AWS News Blog
AWS News Blog
GbyAI
GbyAI
腾讯CDC
WordPress大学
WordPress大学
V
V2EX
小众软件
小众软件
C
CXSECURITY Database RSS Feed - CXSecurity.com
M
MIT News - Artificial intelligence
T
Troy Hunt's Blog
H
Hacker News: Front Page
Scott Helme
Scott Helme
The Hacker News
The Hacker News
Schneier on Security
Schneier on Security
K
Kaspersky official blog
S
Security @ Cisco Blogs
N
News | PayPal Newsroom
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
T
Threatpost
奇客Solidot–传递最新科技情报
奇客Solidot–传递最新科技情报
Martin Fowler
Martin Fowler
P
Privacy International News Feed
Blog — PlanetScale
Blog — PlanetScale
D
DataBreaches.Net
O
OpenAI News
P
Proofpoint News Feed
J
Java Code Geeks
B
Blog RSS Feed
Attack and Defense Labs
Attack and Defense Labs
L
Lohrmann on Cybersecurity
T
Threat Research - Cisco Blogs
C
Cybersecurity and Infrastructure Security Agency CISA
阮一峰的网络日志
阮一峰的网络日志
P
Palo Alto Networks Blog
Engineering at Meta
Engineering at Meta
AI
AI
Google DeepMind News
Google DeepMind News
雷峰网
雷峰网
Microsoft Azure Blog
Microsoft Azure Blog
Simon Willison's Weblog
Simon Willison's Weblog
人人都是产品经理
人人都是产品经理
T
Tailwind CSS Blog
G
GRAHAM CLULEY
A
Arctic Wolf
N
Netflix TechBlog - Medium
L
LINUX DO - 最新话题
爱范儿
爱范儿
博客园 - 聂微东

博客园 - flyinsky

I'm back Sorry? hotmail Note book is for sale Party No title Thirteen life philosophies 何去何从 Change 10/20 Bye,Ottawa 10/18 FxCop Age I hate the advertisements in 5460 Software development ------ imaginative job ? Anger Meaning of life Apply for offer
Maximum row size in SQLServer
flyinsky · 2004-11-01 · via 博客园 - flyinsky

When I execute the command below

CREATE TABLE [CST_SAY3] (
 [BAS_ID] [int],
 [PRO_DETAIL] [Nvarchar] (4000) ,
 [REMARK] [Nvarchar] (3000)
) ON [PRIMARY]
GO

It will make a warning

Warning: The table 'CST_SAY3' has been created
but its maximum row size (14029) exceeds the maximum number
of bytes per row (8060).
INSERT or UPDATE of a row in this table will fail if the
resulting row length exceeds 8060 bytes.

Although I know the reason (In Microsoft® SQL Server™, the maximum allowable size of a row in a table is 8060 bytes. A row cannot be split across data pages. A data page is 8 KB in size and consists of the data row and some internal data structures.)  , I don't know why the maximum row size is
14029, a field is Nvarchar(4000), the bytes is 8000, another field is Nvarchar(3000), the bytes is 6000,
the last field is int , why it's bytes is 29?
 Can someone give me the answer, thanks.