SQL Server数据库建表及插数据
一、建表
CREATE TABLE[dbo] . [SQL表名](
[T_ID] [numeric] (20) not null,
[T_BIGINT] [bigint] null,
[T_CHAR] [char] (20) COLLATE Chinese_PRC_CI_AS not null,
[T_VARCHAR] [varchar] (20) COLLATE Chinese_PRC_CI_AS not null,
[T_NCHAR] [nchar] null,
[T_NVARCHAR] [nvarchar] null,
[T_DATETIME] [datetime] null,
[T_SMALLDATETIME] [smalldatetime] null,
[T_VARBINARY] [varbinary] (2000) null,
[T_BINARY] [binary] (20) null,
[T_IMAGE} [image] null,
[T_TEXT] [text] COLLATE Chinese_PRC_CI_AS null,
[T_NTEXT] [ntext] COLLATE Chinese_PRC_CI_AS null,
[T_UNIQUEIDENTIFIER] [uniqueidentifier] null,
[T_XML] [xml] null,
[T_BIT] [bit] null
);
ALTER TABLE SQL