Wednesday, May 9, 2018

Working With Null Values in SQL

SELECT Field1,Field2,ISNULL(Field3,'') + ' ' + isnull(Field4,'') as Parm1 FROM TableName 

Remove Restoring On SQL Database

RESTORE DATABASE  DB_Name WITH RECOVERY
GO

Custom Validation Message with HTML5

< input type="text" id="username" required placeholder="Enter Name" oninvalid="this.setCustomValidity('Enter User Name Here')" oninput="this.setCustomValidity('')"/>