CREATE procedure Order01(@order varchar(50))
/*
@order 排序方式
*/
asCREATE TABLE #Temp01 (
[inviterID] [int] IDENTITY (1, 1) NOT NULL ,
[name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[sex] [bit] NULL ,
[birthday] [datetime] NULL ,
[eduLevel] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[technialTitle] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[status] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[workDate] [datetime] NULL ,
[finishSchool] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[speciality] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[graduateDate] [datetime] NULL ,
[workPlace] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[unitDuty] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[tel] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[re] [text] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
exec('
insert into #Temp01 select name,sex,birthday,eduLevel,technialTitle,status,workDate,finishSchool,speciality,graduateDate,workPlace,unitDuty,tel,re
from InviterInfo order by '+@order)select * from #Temp01Go
/*
@order 排序方式
*/
asCREATE TABLE #Temp01 (
[inviterID] [int] IDENTITY (1, 1) NOT NULL ,
[name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[sex] [bit] NULL ,
[birthday] [datetime] NULL ,
[eduLevel] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[technialTitle] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[status] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[workDate] [datetime] NULL ,
[finishSchool] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[speciality] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[graduateDate] [datetime] NULL ,
[workPlace] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[unitDuty] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[tel] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[re] [text] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
exec('
insert into #Temp01 select name,sex,birthday,eduLevel,technialTitle,status,workDate,finishSchool,speciality,graduateDate,workPlace,unitDuty,tel,re
from InviterInfo order by '+@order)select * from #Temp01Go
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货