论坛 › SQL Server › SQL sever 取得档案名字与扩展名 split get file name and extension

资讯王 发表于 2010-12-28 16:47:07

SQL sever 取得档案名字与扩展名 split get file name and extension

SQL sever 不必写函数，select指令轻松取得档案名字与扩展名 No need function, select command split and get filename and extension

http://4.bp.blogspot.com/_4EWpEzDdWxo/TRmi8Ce8HAI/AAAAAAAABaI/9rOc4yOgFbo/s400/fileName.jpg

取档案名字 get file nameSELECT   (SUBSTRING((FileName), 1, CHARINDEX('.', (FileName)) - 1)) AS FileName
FROM         tblFile取档案扩展名 get file name extensionSELECT   REVERSE(SUBSTRING(REVERSE(FileName), 1, CHARINDEX('.', REVERSE(FileName)) - 1)) AS FileExt
FROM         tblFile

查看完整版本: SQL sever 取得档案名字与扩展名 split get file name and extension