嗨，朋友，我需要sql表的列值以这种格式显示 [英] Hi Friends I need sql table column values to display in this format

问题描述

我有一个表Employee，列名为Employee_Id，Employee_Name....在该表中，我有以下值
Employee_Id Employee_Name
EMP_01 A

I have a table Employee with column name as Employee_Id,Employee_Name....In that table i have following values
Employee_Id Employee_Name
EMP_01 A

EMP_10           J
EMP_11           K
EMP_12           L
EMP_13           M
EMP_02           B
EMP_03           c
EMP_04           D
EMP_05           E
EMP_06           F
EMP_07           G
EMP_08           H
EMP_09           I

我需要在DropDown中绑定Employee ID .... 1 ... 11即将进入sql表后，Employee ID不是连续的....绑定之后，我需要EMP_1,2,3,4，...

I need to bind Employee ID in DropDown ....Employee Id is not in continuous after 1 ...11 is coming in sql table....After binding i need EMP_1,2,3,4,...

推荐答案

您好，请使用以下链接:

http://stackoverflow.com/questions/34509/natural- human-alpha-numeric-sort-in-microsoft-sql-2005 [

Hi, use following link:

http://stackoverflow.com/questions/34509/natural-human-alpha-numeric-sort-in-microsoft-sql-2005[^]

it will helpful for you. :-)

嘿，

在查询中使用order by.
祝你好运

hey,

use order by in Your Query.
Good Luck

这篇关于嗨，朋友，我需要sql表的列值以这种格式显示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！