摘要:
WITH treeAS(SELECT ParentAssetID, AssetID,1 AS x2level,nodename,CAST(nodename AS NVARCHAR(max)) x2name,CAST(+AssetID AS NVARCHAR(max)) x2idFROM dbo.As 阅读全文
posted @ 2016-11-08 09:26
明净
阅读(281)
评论(0)
推荐(0)
|
摘要:
WITH treeAS(SELECT ParentAssetID, AssetID,1 AS x2level,nodename,CAST(nodename AS NVARCHAR(max)) x2name,CAST(+AssetID AS NVARCHAR(max)) x2idFROM dbo.As 阅读全文
posted @ 2016-11-08 09:26
明净
阅读(281)
评论(0)
推荐(0)
|