SQL server 常用的 一些函数

2017-12-11 10:52:21来源:oschina作者:Lucky_Me人点击

分享

1.sql server 中使用的函数


select convert(varchar, dbo.AvgLimit(a.longitude_du+a.longitude_miao/3600.0+a.longitude_fen/60.0,10)) as longitude ,convert(varchar,dbo.AvgLimit( a.latitude_du+a.latitude_miao/3600.0+a.latitude_fen/60.0,6)) as latitude ,a.id as tid ,convert(varchar,a.site_code) as code,a.site_name as name,'' as name2 ,'' as number ,'2' as type,'' as status from t_air_basicinfo a order by update_date desc

最新文章

123

最新摄影

微信扫一扫

第七城市微信公众平台