增加sql server varchar字段大小对应用程序的影响
考虑到我正在开发使用 .net Framework 1.1 的遗留应用程序，将 sql server 数据库上的 varchar 字段的大小从 50 增加到 60 会产生什么影响？
What is the effect of increasing the size of a varchar field from 50 to 60 on a sql server database taking into consideration that i am working on a legacy application working with .net framework 1.1 ?!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
50到60是相当微不足道的。如果列上有索引，当您向列中添加较大尺寸的数据时，您会在索引中看到稍微多一些的页面，因为单个页面上适合的值较少。除此之外，我认为仅就尺寸而言并没有太大影响。您还必须考虑查询和代码。您可能还存在必须关注的约束。我能想到的就这么多了。
50 to 60 is pretty trivial. If there's an index on the column you'll see slightly more pages in the index as you add larger sized data to the column since fewer values will fit on a single page. Other than that, I don't see much of an impact just referring to the size. You will have query and code that you'll have to take into account as well. You might also have a constraint that you have to be concerned with. That's about all I can think of.