usp_chapter12ex1.sql

来自「数据库学习的绝好例子简单的数据库经典入门」· SQL 代码 · 共 8 行

CREATE PROCEDURE usp_Chapter12Ex1
AS

SELECT FirstName + ' ' + LastName AS UserName, RoleName
FROM Users
JOIN Roles ON Users.RoleID = Roles.RoleID
ORDER BY UserName