做了个例子，在BaiduSqlServerQAndA数据库中建立员工表：USE [BaiduSqlServerQAndA]GO/****** 对象:Table [dbo].[Employee]
脚本日期: 12/29/2009 16:06:06 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TABLE [dbo].[Employee]( [EmployeeNo] [int] NOT NULL, [NTAccount] [nvarchar](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL, [Name_Chi] [nvarchar](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL, [Birthday] [datetime] NOT NULL, [DeptName] [nvarchar](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL, [Email] [nvarchar](50) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL, CONSTRAINT [PK__Employee__76CBA758] PRIMARY KEY CLUSTERED ( [EmployeeNo] ASC) ON [PRIMARY]) ON [PRIMARY]插入一行数据：INSERT INTO [BaiduSqlServerQAndA].[dbo].[Employee]
([EmployeeNo]
,[NTAccount]
,[Name_Chi]
,[Birthday]
,[DeptName]
,[Email])
VALUES(10, 'Bill_lee', '李四', '1980/2/20', 'G200', 'Bill_lee@company')更新这一行所有列：UPDATE [BaiduSqlServerQAndA].[dbo].[Employee] SET [EmployeeNo] = 30
,[NTAccount] = 'Gates_lu'
,[Name_Chi] = '张三'
,[Birthday] = '1990/8/18'
,[DeptName] = 'ResearchDepartment'
,[Email] = 'Gates_lu@company' WHERE EmployeeNo=10 |
