1、打开SQLserver数据库
2、创建一张表，插入数据create database TCgouse TCgocreate table tb(id int,name varchar(20),sex char(2),adress varchar(20))goinsert into tb values(1,'张三','男','云南')insert into tb values(2,'李钰','女','韩国')insert into tb values(3,'王五','男','海南')insert into tb values(4,'李莉','女','四川')insert into tb values(5,'钱七','男','吉林')insert into tb values(6,'孙莉','女','广东')
3、--按照名字查找select * from tb where name='孙莉'--按照性别查找se造婷用痃lect * from tb where sex='女'--按照居住地查找select * from tb where adress='吉林'--按照id查找select * from tb where id=1
