Monday , December 11 2017
Home / 2016 / December

Monthly Archives: December 2016

ISNULL() Vs NULLIF() in sqlserver

isnull-vs-nullif

In this article I will explain the differences between the ISNULL() and NULLIF() functions in SQL Server 2012. ISNULL() Function The ISNULL() function is used to replace NULL with the specified replacement value. This function contains only two arguments. Syntax ISNULL (check_exp, change_value) Example 1 : Select ISNULL(null,15) ‘ISNULL VALUE’ output: 15 …

Read More »

How to Use Remote Validation in MVC

Remote Validation

Remote Validation Attribute allows us to validate properties values with server callback using AJAX. Remote Validation Attribute is available in System.Web.MVC. Let an Example User wants to fill details in Registration Page . It contains Fields like UserId, Password, EmailId, Qualification, Mobile Number, Mean while to check whether UserId is …

Read More »

Free Ebook : Introducing Microsoft SQL Server 2016

sql_2016 ebook

Free Ebook : Introducing Microsoft SQL Server 2016 SQL Server 2016 is the latest addition to Microsoft’s data platform, with a variety of new features and enhancements that deliver breakthrough performance, advanced security, and richer, integrated reporting and analytics capabilities. Built using the new rapid-release model, SQL Server 2016 incorporates …

Read More »

AdventureWorks Database collection (2014,2012,2008,2005)

AdventureWorks Database

The AdventureWorks database is a fictitious company database that has existed since SQL Server 2005 as a means to show new functionality in each new version released. Because the Books Online TSQL samples leverage this sample database, AdventureWorks has become a vital aspect of learning new features/constructs within SQL Server. …

Read More »