我的问题是,我有一个存储过程,它选择这个数据并将其转换成XML,但是它失败了,因为特殊字符被转换为,并且在分配给XML变量时它抛出了一个错误:
declare @org NVARCHAR(MAX)
SELECT @org=--'<?CAST((SELECT OrganizationName from organization where OrganizationId=24137603 FOR XML PATH
$qry = mssql_query("SELECT CAST(FirstName_1 AS NVARCHAR(250)) AS Name FROM FirstName_1列是nvarchar类型。我尝试将FirstName_1转换为VARBINARY(8000),然后将结果转换为图像,如下所示。CAST(CAST(FirstName_1 AS VARBINARY(8000)) AS IMAGE) AS N