內容面板收納
(2013-04-22 12:00:34)
分类： ASP.NET开发
E11_Remarks是text，不能group by ，用方法cast。
select E11_PurchaseOrderID ,
E11_ItemID,
E11_ItemModel,
sum(E11_Qty) as E11_Qty,
E11_Manufacturer,
E11_WHID,
E11_UnitPrice,
E11_InStoreDate,
cast(E11_Remarks as varchar(4000)) as E11_Remarks,
E11_RsvedFld
from E11_ServiceItemStore
group by E11_PurchaseOrderID,
E11_ItemID,
E11_ItemModel,
E11_Manufacturer,
E11_WHID,
E11_UnitPrice,
E11_InStoreDate,
cast(E11_Remarks as varchar(4000)),
E11_RsvedFld
不能做 group by 所以要convert欄位屬性
group by convert(varchar(255),欄位)
微軟建議：使用varchar(max) 來代替text
使用nvarchar(max) 來代替ntext
使用varbinary(max) 來代替image
分类： ASP.NET开发
E11_Remarks是text，不能group by ，用方法cast。
select E11_PurchaseOrderID ,
E11_ItemID,
E11_ItemModel,
sum(E11_Qty) as E11_Qty,
E11_Manufacturer,
E11_WHID,
E11_UnitPrice,
E11_InStoreDate,
cast(E11_Remarks as varchar(4000)) as E11_Remarks,
E11_RsvedFld
from E11_ServiceItemStore
group by E11_PurchaseOrderID,
E11_ItemID,
E11_ItemModel,
E11_Manufacturer,
E11_WHID,
E11_UnitPrice,
E11_InStoreDate,
cast(E11_Remarks as varchar(4000)),
E11_RsvedFld
不能做 group by 所以要convert欄位屬性
group by convert(varchar(255),欄位)
微軟建議：使用varchar(max) 來代替text
使用nvarchar(max) 來代替ntext
使用varbinary(max) 來代替image
