如何在下拉列表中按字母顺序显示用户列表 [英] how to display the list of users in alphabetical order in dropdown list

问题描述

大家好，

我有以下存储的proc:

Hi Every one,

I have the below stored proc:

CREATE PROC [dbo].[BINDUSERS]
AS
BEGIN
SET NOCOUNT ON
SELECT Uid,UserName FROM UserDetails WHERE RoleId=2
UNION
SELECT 0,'Select'
END

任何人都可以告诉我如何通过保持值选择"来按字母顺序显示用户名"值
总是在最前面吗?

问候，

Could any one please tell me how to display the "Username" values in alphabetical order by keeping the value ''Select''
always on top ?

Regards,

推荐答案

尝试一下，它将起作用

Try this it will work

CREATE PROC [dbo].[BINDUSERS]
AS
BEGIN
SET NOCOUNT ON
Select * from (
SELECT Uid,UserName FROM UserDetails WHERE RoleId=2
UNION
SELECT 0,''All'') alluser order by UserName
END

你可以用这个

you can use this

CREATE PROC [dbo].[BINDUSERS]
AS
BEGIN
SET NOCOUNT ON
Select * from (
SELECT Uid,UserName, UserName as ForOrdering FROM UserDetails WHERE RoleId=2
UNION
SELECT 0,'All','~') alluser order by ForOrdering
END

[/编辑]
--Pankaj

[/Edit]
--Pankaj

尝试

SELECT Uid,UserName FROM UserDetails WHERE RoleId=2
UNIONSELECT 0,''All'' 
Order by 2

这篇关于如何在下拉列表中按字母顺序显示用户列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！