日期:2014-05-18  浏览次数:20555 次

关于SQL的排序问题????????????????
请问在SQL的自定义函数中是否能加ORDER   BY   这样的排序,怎样做??谢谢

------解决方案--------------------
CREATE FUNCTION dbo.ISOweek (@s varchar(100))
RETURNS TABLE
AS
RETURN (select top 10 city from dbo.datable where province like @s order by startip)
select * from dbo.ISOweek ( '%广州% ')
city
--------------------------------------------------
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL