Thursday, May 16, 2013

how replace null to 0 in sql query

If you want to replace the null value in 0 in your sql query like the output:






you have to just write as  ISNULL(DC_Requisition.MainStockID,0) as MainStockId

vfpoledeb.1 provider is not registered on the local machine

Have u Install VFP Ole DB Provider in your System ? If No then Please Install it from following link. http://www.microsoft.com/download...