日期:2014-05-17 浏览次数:20480 次
select ID, OrderID, LastName, FirstName, CardholderSinceDate, AddressStreet1, Mobilephone, City, StateOrProvince, PostalCode, CountryCode, CustomerID, LoyaltyCardNumber, GoldCardnumber, GoldCardPIN, Email, StoreNumber, EMSFirstName, EMSLastName, DataType, IsError, CreateDate, ImportUser, Batch, ShipDate, ExpressTrackingCode, UpdateDate, UpdateUser,
ReturnReason, ReturnDate, TID, IsHandle, DataSource, IsUpdateBOH
from GoldCardReplacementData
where LoyaltyCardNumber='6010581952359804'
select ReturnDate=CASE WHEN CONVERT(DATETIME, ReturnDate) = '1900-1-1' THEN '' ELSE ReturnDate END from GoldCardReplacementData WHERE LoyaltyCardNumber = '6010581952359804'
SELECT ID ,
OrderID ,
LastName ,
FirstName ,
CardholderSinceDate ,
AddressStreet1 ,
Mobilephone ,
City ,
StateOrProvince ,
PostalCode ,
CountryCode ,
CustomerID ,
LoyaltyCardNumber ,
GoldCardnumber ,
GoldCardPIN ,
Email ,
StoreNumber ,
EMSFirstName ,
EMSLastName ,
DataType ,
IsError ,
CreateDate ,
ImportUser ,
Batch ,