在SQL中创建表 [英] Creating Tables in SQL

问题描述

我从SQL数据库开始，我需要在表中创建varchar(max).问题是我正在使用ASP.Net Enterprise Manager，并且在表编辑器中不允许我输入值MAX，因为它必须是整数.

查看图片

是否有可能以其他方式创建它?还是我可以做?

Hi, I''m starting with SQL Databases and I need create a varchar(max) in a table. The problem is that I''m using ASP.Net Enterprise Manager and in the table editor will not let me put the value MAX, as it must be an integer.

See the Image

There is the possibility of creating it otherwise? Or I can do?

推荐答案

"max"表示您希望varchar成为的最大字符数.例如，如果您希望该字段表示不超过12个字符的名字，则使用varchar(12)

The "max" means the maximum number of characters you want your varchar to be. e.g if you want the field to represent a first name of not more than 12 characters, you use varchar(12)

很显然，此ASP.Net Enterprise Manager无法识别T-SQL常量.使用整数或使用SQL Server Manager，或者如果您确实有雄心，请使用代码创建表.

Well apparently this ASP.Net Enterprise Manager does not recognize T-SQL constants. Use an integer or use SQL Server Manager or if you were really ambitious create the table with code.

这篇关于在SQL中创建表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！