If any part of the string exceeds 256 bytes, PARSENAME returns NULL for that part, as it's not a valid sysname.object_pieceThe object part to return. object_piece is int, and can be one of these values:ცხრილის გაშლა ...
The PARSENAME function does not indicate whether an object by the specified name exists. PARSENAME just returns the specified part of the specified object name. Is the name of the object for which to retrieve the specified object part.sysname object_piece Is the object part to return.object_pie...
Each part of the 'object_name' string issysname, which is equivalent tonvarchar(128)or 256 bytes. If any part of the string exceeds 256 bytes,PARSENAMEreturnsNULLfor that part, as it's not a validsysname. object_piece The object part to return.object_pieceisint, and can be one of the...
ParseName只能针对.,所以若是其他的分隔字符,需要先替换为. WITHtempAS(SELECT*FROM(VALUES('192.168.3.239'), ('192.168.3.232') )AST (IP) )SELECTIP, PARSENAME(IP,1)ASIP1, PARSENAME(IP,2)ASIP2, PARSENAME(IP,3)ASIP3, PARSENAME(IP,4)ASIP4FROMtemp; IP IP1 IP2 IP3 IP4 --- --- --- -...
第一种:最简单的办法就是调用sql server中自带函数PARSENAME来进行拆分,但是注意:最多只能拆分成4个字段。 针对这个例子的实现:parsename默认是根据'.'进行拆分的,所以首先要做的是将字段中的‘-’替换成'.' SELECT Address, PARSENAME(REPLACE([Address],'-','.'),4) as 小区名, ...
SELECT Address, PARSENAME(REPLACE([Address],'-','.'),4) as 小区名, --如果字段的内容是 4单元-12幢-203 那么此时小区名字段的信息就是NULL PARSENAME(REPLACE([Address],'-','.'),3) as 单元号, PARSENAME(REPLACE([Address],'-','.'),2) as 楼房号, ...
PARSENAME (Transact-SQL) CONCAT (Transact-SQL) CONCAT_WS (Transact-SQL) FORMATMESSAGE (Transact-SQL) REPLACE (Transact-SQL) REVERSE (Transact-SQL) STRING_AGG (Transact-SQL) STRING_ESCAPE (Transact-SQL) STUFF (Transact-SQL) TRANSLATE (Transact-SQL) ...
PARSENAME (Transact-SQL) CONCAT (Transact-SQL) CONCAT_WS (Transact-SQL) FORMATMESSAGE (Transact-SQL) REPLACE (Transact-SQL) REVERSE (Transact-SQL) STRING_AGG (Transact-SQL) STRING_ESCAPE (Transact-SQL) STUFF (Transact-SQL) TRANSLATE (Transact-SQL) String Functions (Transact-SQL)Feed...
--或者借助parsename函数: SELECT PARSENAME(REPLACE(data,',','.'),2) AS StrSplit FROM ( SELECT 'Hello,World,SQL' AS data UNION ALL SELECT 'Data,Arithmetic' AS data UNION ALL SELECT 'Science' AS data )A WHERE PARSENAME(REPLACE(data,',','.'),2) IS NOT NULL 执行结果: --Mysql: SELE...
1 SELECT Address, PARSENAME(REPLACE([Address],'-','.'),4) as 小区名, 2 --如果字段的内容是 4单元-12幢-203 那么此时小区名字段的信息就是NULL 3 PARSENAME(REPLACE([Address],'-','.'),3) as 单元号, 4 PARSENAME(REPLACE([Address],'-','.'),2) as 楼房号, ...