大马资讯论坛 - 马来西亚中文资讯平台

 找回密码
 注册
搜索

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

[复制链接]
发表于 2010-12-28 16:47:07 | 显示全部楼层 |阅读模式
SQL sever 不必写函数,select指令轻松取得档案名字与扩展名 No need function, select command split and get filename and extension



取档案名字 get file name
  1. SELECT     (SUBSTRING((FileName), 1, CHARINDEX('.', (FileName)) - 1)) AS FileName
  2. FROM         tblFile
复制代码
取档案扩展名 get file name extension
  1. SELECT     REVERSE(SUBSTRING(REVERSE(FileName), 1, CHARINDEX('.', REVERSE(FileName)) - 1)) AS FileExt
  2. FROM         tblFile
复制代码

手机版|大马资讯论坛  

GMT+8, 2024-3-29 12:45 , Processed in 0.116615 second(s), 16 queries , File On.

Powered by Discuz! X3.3

© 2001-2017 Comsenz Inc.

快速回复 返回顶部 返回列表