![](https://img-blog.csdnimg.cn/20201014180756930.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL 函数
Felixzhaowenzhong
勤能补拙
展开
-
半角、全角 字符串互转\提取中文或数字
/* 半角字符串转全角 */ if exists (select * from dbo.sysobjects where id = object_id(N '[dbo].[convert_CharSet_BJ2QJ] ') and xtype in (N 'FN ', N 'IF ', N 'TF ')) drop转载 2012-01-13 17:57:32 · 1757 阅读 · 0 评论 -
字符串拆分函数\树形结构函数
USE [mytest] GO /****** Object: UserDefinedFunction [dbo].[fn_get_Split] Script Date: 10/11/2010 09:01:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE FUNCTION [dbo].原创 2012-01-13 18:00:47 · 2099 阅读 · 0 评论