2023/12/4
更新操作(insert、update、delete)
封装
sql脚本
USE [test_system]
GO
/****** Object: Table [dbo].[tb_user] Script Date: 2023/12/4 15:08:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tb_user](
[id] [varchar](24) NOT NULL,
[user_name] [varchar](24) NOT NULL,
[password] [varchar](128) NOT NULL,
CONSTRAINT [PK_tb_user] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
查询操作(select)
标记
2023/12/5
\
2023/12/12