CAST on IMAGE uniqueidentifier Type

// This Statement will use in Export Data>> x sangka berjaya buat
select CAST(SupportingDocID AS VARCHAR(1000)) AS SupportingDocID ,usertransactionID,SupportingDocDescription,

CAST(SupportingDocFile AS varbinary(1000)) As SupportingDocFile ,SupportingDocContentType,SupportingDocBusRegNo,SupportingDocCode,SupportingDocSubmitDate,
SupportingDocReceivedDate,SupportingDocTotalPage,SupportingDocFileName,CreatedDate
from dbo.ROCSupportingDoc where usertransactionid='93002'

Comments

Popular posts from this blog

Kenapa Melayu kerja Gomen?

Apa itu subsidi?

Kullu Man Fil Kauni