usp_selectusers.sql

来自「Beginning VB.NET DatabasesAll_Code.rar」· SQL 代码 · 共 7 行

CREATE PROCEDURE usp_SelectUsers
AS
SELECT UserID, LoginName, FirstName + ' ' + LastName AS UserName,
   Email, Phone, Status
FROM Users
ORDER BY UserName