本文介绍了大小超过900字节的SQL Server主键问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想分配一个列,因为主键大小超过900个字节,并且我得到的列大小超过900个字节错误.我不得不减小大小以使其成为主键.问题-
1.是否有更好的选择将键分配给超过900字节的列大小
2.假设我将列的大小减小到小于900字节并将其分配给主键,但是我的其他列的总大小通常超过900字节,因为要保存许多长数据,在这种情况下将有任何插入和更新问题?
i wanted to assign a column as primary key size is over 900 bytes and i got column size is over 900 bytes error.i had to decrease size to make it a primary key.question -
1.is there any better alternative to assign key to a column size over 900 bytes
2.suppose i decrease size of the column less than 900 bytes and assigned it primary key.but my other columns total sizes are more than 900 bytes as usual as there are many long data to be saved.in that case will there be any insert and update problem?
推荐答案
这篇关于大小超过900字节的SQL Server主键问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!