Question: what is the difference between null and isnull in sql?
Answer: what is difference between NULL and ISNULL in SQL Server 2008? ISNULL is a function which is verify the data is null or not if null then it will replace the value which is assigned in the function. NULL is default values if no data present. Commit is a TCL command which is used to make database transaction permanent.