philzhou

摘要： 原文 SQL Server FOR XML PATH 语句的应用在SQL Server中利用 FOR XML PATH 语句能够把查询的数据生成XML数据，下面是它的一些应用示例。view sourceprint?1DECLARE @TempTable table(UserID int , UserName nvarchar(50));2insert into @TempTable (UserID,UserName) values (1,'a')3insert into @TempTable (UserID,UserName) values (2,'b')45s 阅读全文

摘要： Execute the following Microsoft SQL Server T-SQL example scripts to demonstrate SQL padding of numbers and strings with leading and trailing zeros as well as with other designated characters, and techniques for removing (trim) leading zeros. 使用以下sql server t-sql 脚本添加删除前导，后缀字符。-- Add/pa... 阅读全文