Skip to content

Instantly share code, notes, and snippets.

@FelicePollano
FelicePollano / search.sql
Last active July 31, 2023 13:54
Search all table, all columns for a specific ( numeric ) value is SQLServer
declare @serchval varchar(20) = '12347'
declare @table_name varchar(max), @col_name varchar(max),@sql varchar(max)
create table #results (table_name varchar(100), column_name varchar(100))
declare crunch_all cursor forward_only for
select t.table_schema+'.'+t.table_name table_name,c.COLUMN_NAME col_name from INFORMATION_SCHEMA.TABLES t
inner join INFORMATION_SCHEMA.COLUMNS c on c.TABLE_NAME = t.TABLE_NAME and c.TABLE_SCHEMA = t.TABLE_SCHEMA
where c.DATA_TYPE in ('int','decimal','smallint','float','real')
open crunch_all
@FelicePollano
FelicePollano / gist:901970b3625cf0e516f31495cbba6c46
Last active February 2, 2022 16:39
Java simple inheritance
class Person
{
public void sayHello()
{
System.out.println("Hello World");
}
}
class Employee extends Person
{
public void sayHello()
@FelicePollano
FelicePollano / error-616.txt
Created January 30, 2012 14:38
raven.mediumtrust
[SecurityException: That assembly does not allow partially trusted callers.]
Raven.Database.Util.PortUtil..cctor() +0
@FelicePollano
FelicePollano / propertychangedbase.cs
Created January 18, 2012 16:14
notify property changed with expression
class PropertyChangeBase : INotifyPropertyChanged
{
protected void SignalChanged<T>(Expression<Func<T>> exp)
{
if (exp.Body.NodeType == ExpressionType.MemberAccess)
{
var name = (exp.Body as MemberExpression).Member.Name;
PropertyChanged(this, new PropertyChangedEventArgs(name));
}
else
@FelicePollano
FelicePollano / SwapperTest.cs
Created January 18, 2012 11:22
Genric SWAP
public class SwapperTest
{
public class Test_
{
public int X { get; set; }
public int Y { get; set; }
}
[TestMethod]
@FelicePollano
FelicePollano / addressresolver.cs
Created January 13, 2012 10:41
AdderssResolver
public class AddressResolver
{
string language = "en-GB";
public AddressResolver()
{
}
public AddressResolver(string language)
{
this.language = language;
@FelicePollano
FelicePollano / RouteResolver.cs
Created January 13, 2012 10:40
RouteResolver
public class RouteResolver
{
string language = "en-GB";
public RouteResolver()
{
}
public RouteResolver(string language)
{
@FelicePollano
FelicePollano / haversine.cs
Created January 10, 2012 16:02
Haversine
public static class Haversine
{
private static double ToRadiant(this double ang)
{
return ang * Math.PI / 180.0;
}
private static double ToDeg(this double ang)
{
return ang / Math.PI * 180.0;
}
static class PredicateRewriter
{
public static Expression<Predicate<T>> Rewrite<T>(Expression<Predicate<T>> exp
, string newParamName)
{
var param = Expression.Parameter(exp.Parameters[0].Type, newParamName);
var newExpression = new PredicateRewriterVisitor(param).Visit(exp);
return (Expression<Predicate<T>>)newExpression;
}
public interface IContract<T>
{
IContract<T> Is<TT>();
IContract<T> IsEqual<TT>(TT of) where TT : T,IEquatable<TT>;
IContract<T> IsGreatherThan<TT>(TT of) where TT : T,IComparable;
IContract<T> IsGreatherThanOrEqual<TT>(TT of) where TT :T, IComparable;
IContract<T> IsLessThan<TT>(TT of) where TT : T,IComparable;
IContract<T> IsLessThanOrEq<TT>(TT of) where TT : T,IComparable;
IContract<T> IsNot<TT>();
IContract<T> IsNotEqual<TT>(TT of) where TT : T,IEquatable<TT>;