要写个存储过程,根据我的需要排序这么写好像不行
create procedure select_by_order
(@order_by,nchar(30))
as
select id,num,type from table
order by @order_by
go求教应该怎么写,谢谢
create procedure select_by_order
(@order_by,nchar(30))
as
select id,num,type from table
order by @order_by
go求教应该怎么写,谢谢
@order_by nchar(30)
as
select id,num,type from table order by @order_by
go
http://blog.csdn.net/sun_jianhua/archive/2004/07/04/33574.aspx