IIF function is new to SQL Server Denali however if you worked with MS Access then you are familiar with this function. So if you are upgrading a database from Access to SQL Server Denali you don’t need to worry about rewriting the IIF function queries. IIF function will evaluate the expression and it will return one value out of two input values. This function is similar to CASE function however you can evaluate the expression for two values and not more than that.

Yesterday we discussed about time function, today we are going to see DATEFROMPARTS function which is new in SQL Server Denali. It will return a date value for the specified year, month and day.  All the arguments should be valid else error is thrown, if you have NULL value in argument then NULL is returned.

We are going to discuss another new function that’s going to get released with SQL Server Denali. This function is related to date time category. This is similar to the early function which we saw. Time returns a fully initialized time value. If the arguments are invalid then an error is raised, if you have NULL value in argument then NULL is returned.

Today I’m going to give you a short demo on the new date time function in SQL Server Denali. It’s SMALLDATETIMEFROMPARTS function, are you able to get the things from naming convention. Yep! you are right, this function will return small datetime value with the parts of data being supplied to the function. I hope previously we did this with convert or cast function.

Today we are going to see a new datetime function that’s introduced with SQL Server Denali. This function is expected by many of the developers, this function will let you know the last date of a month. It’s EOMONTH(), you can pass the date as input , it will give you the end date of that month.