Microsoft SQL 插入删除创建

发布时间: 更新时间: 总字数:128 阅读时间:1m 作者: 分享

Microsoft SQL 插入删除创建

插入 INSERT

INSERT INTO [student].[dbo].[stumsg]
       ([name]
       ,[sex]
       ,[num]
       ,[professional]
       ,[grade]
       ,[class]
       ,[address]
       ,[remarks])
    VALUES
       ('小谢'
       ,'男'
       ,541007010144
       ,'计科'
       ,10
       ,1
       ,'河南商丘'
       ,'无')

删除 DELETE

DELETE FROM
[student].[dbo].[stumsg]
WHERE [num]=541007010144

创建CREATE

USE [student]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[stumsg](
    [name] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
    [sex] [char](10) COLLATE Chinese_PRC_CI_AS NULL,
    [num] [numeric](20, 0) NULL,
    [professional] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
    [grade] [int] NULL,
    [class] [int] NULL,
    [address] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,
    [remarks] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

参考

Home Archives Categories Tags Docs