SELECT t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE '%ColumnName%'
ORDER BY schema_name, table_name;
Friday, September 20, 2013
Query to Find Column From All Tables of Database
Tuesday, September 3, 2013
How to change the Change/Assign Dropdown/Radio Button Values in Jquery Mobile
Method #1 ( DropDown )
var
countrySetValue = $("#deliveryMethod");
$('#deliveryMethod').val('-1');
countrySetValue.selectmenu("refresh", true);
Method #2 ( DropDown )
$("#deliveryMethod").selectmenu("refresh",
true);
Method #1 ( Radio Button )
$('input[name=PaymentType]').removeAttr('checked').checkboxradio("refresh");
Subscribe to:
Posts (Atom)