关于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