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

Popular posts from this blog

WPF Crystal Report Viewer Using SAP

mvc razor textboxfor change event change another textboxfor value

ASP.NET MVC razor SAP Crystal report