create database XJH
go
use XJH
go
create table student
(
studentId int primary key identity(1,1),--学生Id
stName varchar(30),--学生姓名
)
insert into student values('Afghanistan')
insert into student values('Aringland Islands')
insert into student values('Algeria')
insert into student values('Andorra')
insert into student values('Angola')
insert into student values('Anguilla')
insert into student values('Antarctica')
insert into student values('Antigua and Barbuda')
insert into student values('Argentina')
insert into student values('Armenia')
insert into student values('Aruba')
insert into student values('Australia')
insert into student values('Austria')
insert into student values('Azerbaijan')
insert into student values('Bahamas')
insert into student values('Bahrain')
insert into student values('Bangladesh')
insert into student values('Barbados')
insert into student values('Belarus')
insert into student values('Belgium')
insert into student values('Belize')
insert into student values('Benin')
insert into student values('Bermuda')
insert into student values('Bhutan')
insert into student values('Bolivia')
insert into student values('Bosnia and Herzegovina')
insert into student values('Botswana')
insert into student values('Bouvet Island')
insert into student values('Brazil')
insert into student values('Cambodia')
insert into student values('Cameroon')
insert into student values('Canada')
insert into student values('Cape Verde')
insert into student values('Cayman Islands')
insert into student values('Central African Republic')
insert into student values('Chad')
insert into student values('Chile')
insert into student values('China')
insert into student values('小二')
insert into student values('小三')
insert into student values('小四')
insert into student values('小五')
insert into student values('A工度')
insert into student values('小四')
create proc GetStudentName
as
select a.stName from (select distinct stName from student) as a
go
exec GetStudentName
create proc GetStudentNameBystrName
@strName varchar(30)
as
select from (select distinct stName from student where stName like '@strName%') as a