1、打开SQLserver数据库
2、创建一张表，插入数据
create database TC
go
use TC
go
create table tb
(
id int,
name varchar(20),
sex char(2),
adress varchar(20)
)
go
insert 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='孙莉'
--按照性别查找
select * from tb where sex='女'
--按照居住地查找
select * from tb where adress='吉林'
--按照id查找
select * from tb where id=1
