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

[Khas Wanita] Gangguan Seksual Dan Apa Boleh Dilakukan Jika Menjadi Mangsa?

Apa itu subsidi?

Bagaimana cara untuk memandu Kereta Transmisi Manual. How to Drive a Manual Transmission Car