WPF数据库编程基础1

一、熟悉数据库相关基本命令例：建立StudentDatabase数据库在该数据库下建立student表数据的操作(增删改查)1、创建数据库create database studentDatabase2、创建表create table student(studentNo char(15),studentName char(15))3.插入数据：（1）单行insert语句INSERT INTO student (studenNo,StudentName) VALUES ('小明','001')
(2）多行INSERT语句INSERT INTO [表名] (字段1,字段2) SELECT (字段1,字段2) FROM [表名2] WHERE [条件]2.删除数据：DELETE FROM [表名] WHERE [字段名]条件更新数据：UPDATE [表名] SET [字段1] =,[字段2] = 条件 WHERE [字段三] =条件
3.查询数据：select (字段1,字段2) from [表名] where [条件] order by [字段] desc;4.删除表：Drop table [表名]5.新增字段：ALTER TABLE [表名] ADD [字段名] NVARCHAR (50) NULL
6.删除字段：ALTER TABLE [表名] DROP COLUMN [字段名]7.修改字段：ALTER TABLE [表名] ALTER COLUMN [字段名] NVARCHAR (50) NULL