Tuesday, July 11, 2017

How to check a temporary table exists in SQL Server

Use this sql query
 IF OBJECT_ID('[Your_DB_Name..#[Temp_Table_Name]') IS NOT NULL   
 BEGIN  
      --Action--
 END  

Example
 IF OBJECT_ID('tempdb..#tempDoc') IS NOT NULL   
 BEGIN  
      Drop Table #tempDoc  
 END  


Monday, July 3, 2017

Modal popup over modal popup

Use the given jQuery code in document_ready block.
  var modal_lv = 10000;  
     $('.modal').on('shown.bs.modal', function (e) {  
       $('.modal-backdrop:last').css('zIndex', 1051 + modal_lv);  
       $(e.currentTarget).css('zIndex', 1052 + modal_lv);  
       modal_lv++  
     });  
     $('.modal').on('hidden.bs.modal', function (e) {  
       modal_lv--  
     });  

Sample

Wednesday, June 7, 2017

Function for validating email format using jQuery

 function ValidateEmail(emaliID) {  
     var r = new RegExp("[a-z0-9!#$%&'*+/=?^_`{|}~-]+(?:\.[a-z0-9!#$%&'*+/=?^_`{|}~-]+)*@@(?:[a-z0-9](?:[a-z0-9-]*[a-z0-9])?\.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])?");  
     return (emaliID.match(r) == null) ? false : true;  
   }  


Function for validate dd/MM/yyyy date using jQuery

 function VaidateDate(dateValue)  
   {  
     var dateRegex = new RegExp(/^(?=\d)(?:(?:31(?!.(?:0?[2469]|11))|(?:30|29)(?!.0?2)|29(?=.0?2.(?:(?:(?:1[6-9]|[2-9]\d)?(?:0[48]|[2468][048]|[13579][26])|(?:(?:16|[2468][048]|[3579][26])00)))(?:\x20|$))|(?:2[0-8]|1\d|0?[1-9]))([-.\/])(?:1[012]|0?[1-9])\1(?:1[6-9]|[2-9]\d)?\d\d(?:(?=\x20\d)\x20|$))?(((0?[1-9]|1[012])(:[0-5]\d){0,2}(\x20[AP]M))|([01]\d|2[0-3])(:[0-5]\d){1,2})?$/);  
     return dateRegex.test(dateValue);  
   }  

If function return true then it is valid else it is invalid.