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

推荐订阅源

云风的 BLOG
云风的 BLOG
Hacker News: Ask HN
Hacker News: Ask HN
C
CXSECURITY Database RSS Feed - CXSecurity.com
T
The Exploit Database - CXSecurity.com
The Hacker News
The Hacker News
Security Latest
Security Latest
Attack and Defense Labs
Attack and Defense Labs
Application and Cybersecurity Blog
Application and Cybersecurity Blog
Scott Helme
Scott Helme
H
Heimdal Security Blog
K
KPMG report finds enterprise disconnect between AI and its ROI | CIO
WordPress大学
WordPress大学
雷峰网
雷峰网
L
LangChain Blog
Y
Y Combinator Blog
I
Intezer
V
Vulnerabilities – Threatpost
Apple Machine Learning Research
Apple Machine Learning Research
The Last Watchdog
The Last Watchdog
Simon Willison's Weblog
Simon Willison's Weblog
W
WeLiveSecurity
P
Privacy International News Feed
V
Visual Studio Blog
T
The Blog of Author Tim Ferriss
A
About on SuperTechFans
AI
AI
博客园 - Franky
Hacker News - Newest:
Hacker News - Newest: "LLM"
Martin Fowler
Martin Fowler
K
Kaspersky official blog
U
Unit 42
S
Schneier on Security
Webroot Blog
Webroot Blog
Know Your Adversary
Know Your Adversary
T
Tor Project blog
aimingoo的专栏
aimingoo的专栏
Engineering at Meta
Engineering at Meta
G
GRAHAM CLULEY
美团技术团队
TaoSecurity Blog
TaoSecurity Blog
C
Cybersecurity and Infrastructure Security Agency CISA
Google DeepMind News
Google DeepMind News
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
Jina AI
Jina AI
钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知
人人都是产品经理
人人都是产品经理
P
Proofpoint News Feed
爱范儿
爱范儿
F
Fortinet All Blogs
有赞技术团队
有赞技术团队

博客园 - 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.