SELECT c.name AS ColName, t.name AS TableName
FROM sys.columns c
JOIN sys.tables t ON c.object_id = t.object_id
WHERE c.name LIKE '%MyCol%';
Monday, June 25, 2018
Find all table names with column name in sql
Tuesday, May 15, 2018
Check date is valid or not in JavaScript
Find a function to check date is valid or not in Java script
/**
* Get the number of days in any particular month
* @param {integer} m The month (valid: 0-11)
* @param {integer} y The year
* @return {integer} The number of days in the month
*/
var daysInMonth = function (m, y) {
switch (m) {
case 1:
return (y % 4 == 0 && y % 100) || y % 400 == 0 ? 29 : 28;
case 8: case 3: case 5: case 10:
return 30;
default:
return 31
}
};
/**
* Check if a date is valid
* @param {[type]} d The day
* @param {[type]} m The month
* @param {[type]} y The year
* @return {Boolean} Returns true if valid
*/
var isValidDate = function (d, m, y) {
m = parseInt(m, 10) - 1;
return m >= 0 && m < 12 && d > 0 && d <= daysInMonth(m, y);
};
Calling From Function:-
var bits = tempVal.split('/');
alert(isValidDate(bits[0], bits[1], bits[2]));
Example:-
isValidDate(30, 3, 2013); // March 30, 2013 - true
isValidDate(29, 2, 2013); // February 29, 2013 - false
isValidDate(29, 2, 2012); // February 29, 2012 - true
Tuesday, April 24, 2018
What in Func in c#
Func is a generic delegate that encapsulates a method that can accept parameters and return some value
//Annonymous function
Func MyFun1 = delegate(int[] a)
{
string tempString = "";
foreach (int num in a) {
tempString += num.ToString() + ",";
}
return tempString;
};
//Generic or Arrow function
Func MyFun2 = (a) =>
{
string tempString = "";
foreach (float num in a)
{
tempString += num.ToString() + ",";
}
return tempString;
};
private T[] Sort(T[] inputArray)
{
//Sort array
//and return sorted array
return inputArray;
}
int[] numArray = { 10, 15, 26, 98, 68 };
float[] floatArray = { 10.9F, 15.5F, 26, 98.8F, 68 };
lblMessage.Text = "Num : " + MyFun1.Invoke(Sort(numArray));
lblMessage.Text += "Float : " + MyFun2.Invoke(Sort(floatArray));
//Annonymous function
Func
{
string tempString = "";
foreach (int num in a) {
tempString += num.ToString() + ",";
}
return tempString;
};
//Generic or Arrow function
Func
{
string tempString = "";
foreach (float num in a)
{
tempString += num.ToString() + ",";
}
return tempString;
};
private T[] Sort(T[] inputArray)
{
//Sort array
//and return sorted array
return inputArray;
}
int[] numArray = { 10, 15, 26, 98, 68 };
float[] floatArray = { 10.9F, 15.5F, 26, 98.8F, 68 };
lblMessage.Text = "Num : " + MyFun1.Invoke(Sort(numArray));
lblMessage.Text += "Float : " + MyFun2.Invoke(Sort(floatArray));
Friday, April 13, 2018
Compare two dates in javascript
var yearDiff = 100;
var d = new Date();
var year = d.getFullYear();
var month = d.getMonth();
var day = d.getDate();
var dtToday = new Date(year - yearDiff , month, day)
mydate = new Date(DOBDate);
year = mydate.getFullYear();
month = mydate.getMonth();
day = mydate.getDate();
mydate = new Date(year, month, day);
if (mydate > dtToday) {
alert("Age can not be greater than 100 years.");
}
else {
alert("Prev Smaller");
}
var d = new Date();
var year = d.getFullYear();
var month = d.getMonth();
var day = d.getDate();
var dtToday = new Date(year - yearDiff , month, day)
mydate = new Date(DOBDate);
year = mydate.getFullYear();
month = mydate.getMonth();
day = mydate.getDate();
mydate = new Date(year, month, day);
if (mydate > dtToday) {
alert("Age can not be greater than 100 years.");
}
else {
alert("Prev Smaller");
}
Tuesday, March 27, 2018
Get Publish page url and title in sitefinity
SELECT sf_page_node.Title_,
_url_parent =
CASE WHEN (sf_page_node_2.url_name_ = N'Pages') THEN '/'
ELSE
sf_page_node_2.url_name_ +'/'
END,
sf_page_node.url_name_ AS url_page
FROM
sf_page_node LEFT OUTER JOIN
sf_page_node AS sf_page_node_2
ON sf_page_node.parent_id = sf_page_node_2.id
WHERE (sf_page_node.root_id =
(
SELECT id FROM sf_page_node AS sf_page_node_1 WHERE (nme = 'FrontendSiteMap')
)
) AND
(sf_page_node.show_in_navigation = 1) AND
(sf_page_node.render_as_link = 1) AND
(sf_page_node.node_type = 0) AND
(sf_page_node.approval_workflow_state_ = N'Published')
Query 2:-
SELECT sf_page_node.title_ AS "Page Title", sf_sites.nme AS "Site"
FROM sf_page_node
JOIN sf_sites on sf_page_node.root_id = sf_sites.site_map_root_node_id
WHERE sf_site.nme = 'ProjectName'
Subscribe to:
Posts (Atom)