SQL Query to find all tables in a Database containing specified column name

Following query will help to find field name available in any of the table in a database.

SELECT * from INFORMATION_SCHEMA.COLUMNS 
where COLUMN_NAME like '%ColumnName%' 
order by TABLE_NAME



SQL Server:

SELECT Table_Name, Column_Name 
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_CATALOG = 'YOUR_DATABASE'
AND COLUMN_NAME LIKE '%YOUR_COLUMN%'


Oracle:

SELECT owner, table_name, column_name 
FROM all_tab_columns 
WHERE column_name LIKE '%YOUR_COLUMN_NAME%'

AND OWNER IN ('YOUR_SCHEMA_NAME');

Sort JSON object Array

Sort JSON object Array

var array = [{ "No": "12", "Name": "Sameer Patel", "Training": "SharePoint" }, { "No": "2", "Name": "Syam Shah", "Training": "ASP.NET" }, { "No": "11", "Name": "Sunil Shah", "Training": "JAVA" }, { "No": "8", "Name": "Arun Nair", "Training": "Sql Server" }, { "No": "6", "Name": "Anil Patel", "Training": "C#" }]; //Sorting Function function SortBy(prop) { return function(a, b) { if (a[prop] > b[prop]) { return 1; } else if (a[prop] < b[prop]) { return -1; } return 0; } } //array.sort(SortBy("KeyName")) array.sort(SortBy("No"))

Convert Dropdown to Textbox with JQuery

Here is the simple way to convert dropdown to text.


<style> .red{background:red;} </style> <select id='ddl'> <option value='1'>Item1</option> <option value='2'>Item2</option> <option value='3'>Item3</option> <option value='4'>Other</option> </select> <select id='ddl2'> <option value='1'>Item1</option> <option value='2'>Item2</option> <option value='3'>Item3</option> <option value='4'>Item4</option> </select> <script> //runtime on selection of option = 4 $('#ddl').live('change', function () { if ((this.value) == 4) { $(this).replaceWith($('<input/>',{'type':'text','value':'Other'})); } }); $("#ddl2").replaceWith($('<input/>',{'type':'text','value':'Other','readonly':'readonly','class':'red'})); </script>

Extract only text content from HTML in Javascript

1. Create a temporary DOM element and retrieve the text

/* Returns the text from a HTML string */ function GetPlanText_FromHtml(html){ // Create a new div element var tmp = document.createElement("div"); // Set the HTML content with the providen tmp.innerHTML = html; // Retrieve the text property of the element (cross-browser support) return tmp.textContent || tmp.innerText || ""; } var myHTML_String= "<div> <h1> Hello World</h1> <p> This is Extracted string from HTML</p> </div> "; //Hello World //This is Extracted string from HTML console.log(GetPlanText_FromHtml(myHTML_String));

2. using jQuery

var myHTML_String= "<div> <h1> Hello World</h1> <p> This is Extracted string from HTML</p> </div> "; var HTML2Text= $("<div> ").html(myHTML_String).text();

JQuery to create Download Link

Simple way to download file without navigating.

function downloadFile(filePath){ var link=document.createElement('a'); link.href = filePath; link.download = filePath.substr(filePath.lastIndexOf('/') + 1); link.click(); } downloadFile('filepath/myfile.xlsx');

Convert CSV data to JSON

CSV Data

Output as JSON

JSON Group by count, output to key value pair json result

Following is the JSON and need to manipulate it in format to groupBy.

var rows = [ { 'createdDate': '3/11/2016', 'createdBy': 'Bob' }, { 'createdDate': '3/12/2016', 'createdBy': 'Megan' }, { 'createdDate': '3/12/2016', 'createdBy': 'Bob' }, { 'createdDate': '3/13/2016', 'createdBy': 'Sam' }, { 'createdDate': '3/11/2016', 'createdBy': 'Bob' }, ]; var occurences = rows.reduce(function (r, row) { r[row.createdBy] = ++r[row.createdBy] || 1; return r; }, {}); var result = Object.keys(occurences).map(function (key) { return { key: key, value: occurences[key] }; }); console.log(result);