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

推荐订阅源

V
Vulnerabilities – Threatpost
雷峰网
雷峰网
GbyAI
GbyAI
F
Fortinet All Blogs
MyScale Blog
MyScale Blog
MongoDB | Blog
MongoDB | Blog
博客园 - 聂微东
V
V2EX
Jina AI
Jina AI
Apple Machine Learning Research
Apple Machine Learning Research
C
CXSECURITY Database RSS Feed - CXSecurity.com
美团技术团队
Engineering at Meta
Engineering at Meta
T
Tenable Blog
P
Privacy & Cybersecurity Law Blog
Project Zero
Project Zero
Cloudbric
Cloudbric
Help Net Security
Help Net Security
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
L
LINUX DO - 热门话题
J
Java Code Geeks
WordPress大学
WordPress大学
S
Securelist
F
Full Disclosure
N
News and Events Feed by Topic
B
Blog
H
Hackread – Cybersecurity News, Data Breaches, AI and More
I
InfoQ
P
Proofpoint News Feed
Hugging Face - Blog
Hugging Face - Blog
U
Unit 42
Google Online Security Blog
Google Online Security Blog
Spread Privacy
Spread Privacy
P
Proofpoint News Feed
宝玉的分享
宝玉的分享
S
Schneier on Security
T
The Exploit Database - CXSecurity.com
cs.AI updates on arXiv.org
cs.AI updates on arXiv.org
Schneier on Security
Schneier on Security
Google DeepMind News
Google DeepMind News
cs.CV updates on arXiv.org
cs.CV updates on arXiv.org
月光博客
月光博客
Martin Fowler
Martin Fowler
T
Threat Research - Cisco Blogs
小众软件
小众软件
V2EX - 技术
V2EX - 技术
Last Week in AI
Last Week in AI
Stack Overflow Blog
Stack Overflow Blog
The Last Watchdog
The Last Watchdog
D
DataBreaches.Net

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