如何在SQL数据库中插入名称 [英] How to insert name in sql database

问题描述

我在某些示例表数据类型"Name:nvarchar(50)"中找到了.

如何完成的.

在此先感谢

i found in some example table datatype " Name:nvarchar(50) ".

how it is done.

thanks in advance

推荐答案

我不确定我是否理解您的问题.如果您使用的是MS SQL设计器，则只需为该列的数据类型选择nvarchar(50).如果您手动编码仍然不是不可能的任务，例如:

I am not sure I understand your question. If you are using the MS SQL designer, just choose nvarchar(50) for the data type for that column. In case you are hand-coding that still isn''t an impossible task, for example:

CREATE TABLE [dbo].[Test](
    [ID] [int] NOT NULL,
    [Name] [nvarchar](50) NOT NULL
) ON [PRIMARY]

请

Pls. elaborate if this is not what you are looking for.

Name:nvarchar(50)表示声明一个名为 Name 的字段，该字段的可变长度最大为 50 字符，它们也应该以 unicode 格式存储.

Name:nvarchar(50) means that declare a field named Name which would have variable length up to 50 characters and they should also be stored in unicode format.

这篇关于如何在SQL数据库中插入名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！