Tuesday, January 6, 2015

Javascript call a function on Enter button press


Javascript call a function on Enter button press. Like in login ui when you type password then press enter button it will log in.

 $('#id_inputPassword').on('keydown',function(e){  
   e.stopPropagation();  
   if (e.keyCode == 13)  
   {  
     // call your function 
   }  
 });  

SQL get all table column which is null in database

create table #SuspectColumns ( TABLE_SCHEMA sysname, TABLE_NAME sysname, COLUMN_NAME sysname ) declare csrColumns ...