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...