Thursday, August 11, 2011

How to convert Null value of database to some value

If you need to change null value of database at the time of  fetching data from database
then use this method ISNULL
SELECT  ISNull(ColumnName,'Your Converted Value ')  FROM TABLENAME


at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

SQL Optimization

  SQL Optimization  1. Add where on your query  2. If you remove some data after the data return then remove the remove condition in the sel...

  • How Upload Using KendoUI Uploader
    Kendo UI   Uploader : Create a kendo ui uploader control in MVC View @( Html.Kendo().Upload()                 .Name( "fi...
  • Convert string To float
    string float_value="234.4567"; //If data come from databse then first convert it into string then this line; float fl=float.pars...
  • Bind Kendo Grid With Dynamic Column
    We are bind dynamic columns and there values as a rows to Kendo UI grid, To do this we are using a Json file as a data and column list. ...