34,590
社区成员
发帖
与我相关
我的任务
分享
USE tempdb
GO
IF OBJECT_ID('t') IS NOT NULL DROP TABLE t
GO
CREATE TABLE t(
time1 CHAR(100)
)
GO
INSERT INTO t (time1) VALUES ('256')
GO
IF OBJECT_ID('dbo.Fun_String2ASCII') IS NOT NULL
DROP FUNCTION dbo.Fun_String2ASCII
GO
-- =============================================
-- Author: yenange
-- Create date: 2018-06-07
-- Description: 将字符串中的所有字符转换为ASCII码,并用逗号连接
-- =============================================
CREATE FUNCTION dbo.Fun_String2ASCII
(
@str NVARCHAR(MAX)
)
RETURNS NVARCHAR(MAX)
AS
BEGIN
DECLARE @r NVARCHAR(MAX),@s NCHAR(1)
IF ISNULL(@str,'')=''
RETURN @r;
SET @r=''
WHILE LEN(@str)>0
BEGIN
SET @s=LEFT(@str,1);
SET @str=SUBSTRING(@str,2,LEN(@str)-1);
SET @r=@r+RTRIM(ASCII(@s))+',';
END
SET @r=SUBSTRING(@r,1,LEN(@r)-1)
RETURN @r
END
GO
--查一下 ascii 码
SELECT time1,dbo.Fun_String2ASCII(time1) AS asciiCode
FROM t
给个函数给你, 如果有不能转换的看这个就清楚了--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([col] CHAR(100))
Insert #T
select N'同频切换出执行请求次数 '
Go
--测试数据结束
Select CONVERT(INT,col) from #T
同频切换出执行请求次数