1
create
table
UserInfo
2
(
3
UserID
int
primary
key
not
null
,
4
UserName
varchar
(
30
),
5
UserPass
varchar
(
30
),
6
Orders
int
7
)
8
--
-----
9
10
insert
UserInfo
11
values
(
1
,
'
wt
'
,
'
123
'
,
1500
)
12
insert
UserInfo
13
values
(
2
,
'
aa
'
,
'
569
'
,
50
)
14![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
15
insert
UserInfo
16
values
(
3
,
'
ad
'
,
'
56
'
,
160
)
17
insert
UserInfo
18
values
(
4
,
'
ad
'
,
'
99
'
,
806
)
19
insert
UserInfo
20
values
(
5
,
'
df
'
,
'
656
'
,
656
)
21
insert
UserInfo
22
values
(
6
,
'
adsf
'
,
'
adf
'
,
1502
)
23
create
table
GradeUser
24
(
25
GradeUserID
int
primary
key
not
null
,
26
GradeUserName
varchar
(
20
),
27
Orders
int
28
)
29
insert
GradeUser
30
values
(
1
,
'
小学
'
,
0
)
31
insert
GradeUser
32
values
(
2
,
'
中学
'
,
300
)
33![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
34
insert
GradeUser
35
values
(
3
,
'
大学
'
,
800
)
36
insert
GradeUser
37
values
(
4
,
'
博士
'
,
1500
)
38
insert
GradeUser
39
values
(
5
,
'
博导
'
,
15000
)
40
go
41![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
42
--
-------------
43
44
Create
proc
selectUserInfo
45
@UserID
int
46
as
47
set
nocount
on
48
begin
49
select
top
1
u.UserName,u.Orders,g.GradeUserName
50
from
UserInfo u
INNER
JOIN
GradeUser g
51
ON
u.Orders
>=
g.Orders
52
where
u.UserID
=
@UserID
53
order
by
g.GradeUserID
desc
54
end
55
go
56
57
exec
selectUserInfo
2
58
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
2
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
3
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
4
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
5
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
6
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
7
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
8
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
9
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
10
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
11
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
12
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
13
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
14
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
15
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
16
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
17
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
18
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
19
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
20
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
21
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
22
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
23
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
24
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
25
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
26
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
27
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
28
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
29
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
30
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
31
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
32
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
33
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
34
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
35
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
36
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
37
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
38
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
39
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
40
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
41
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
42
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
43
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
44
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
45
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
46
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
47
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
48
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
49
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
50
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
51
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
52
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
53
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
54
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
55
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
56
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
57
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
58
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)