9 lines
No EOL
245 B
Transact-SQL
9 lines
No EOL
245 B
Transact-SQL
DROP FUNCTION IF EXISTS dev.fnConvertBase64
|
|
GO
|
|
|
|
CREATE FUNCTION dev.fnConvertBase64 (@source VARBINARY(MAX))
|
|
RETURNS NVARCHAR(64)
|
|
BEGIN
|
|
RETURN CAST('' AS XML).value('xs:base64Binary(sql:variable(''@source''))', 'varchar(max)')
|
|
END;
|
|
GO |