数据库方面,我会使用binary[16]
column.
然后在 clr 代码中,您可以在自定义类型中重载按位运算符:
public struct My128BitValue
{
private readonly long _l1;
private readonly long _l2;
public My128BitValue(long l1, long l2)
{
_l1 = l1;
_l2 = l2;
}
public static My128BitValue operator &(My128BitValue left, My128BitValue right)
{
return new My128BitValue(left._l1 & right._l1, left._l2 & right._l2);
}
public static My128BitValue operator |(My128BitValue left, My128BitValue right)
{
return new My128BitValue(left._l1 | right._l1, left._l2 | right._l2);
}
public static My128BitValue operator ^(My128BitValue left, My128BitValue right)
{
return new My128BitValue(left._l1 ^ right._l1, left._l2 ^ right._l2);
}
}
CLR基本示例在这里,需要完成FromByteArray
and ToByteArray
方法:
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;
public partial class UserDefinedFunctions
{
[SqlFunction()]
public static SqlBinary bitwiseAnd128Bit(SqlBinary lhs, SqlBinary rhs)
{
My128BitValue v1 = My128BitValue.FromByteArray((byte[])lhs); //explicit conversion
My128BitValue v2 = My128BitValue.FromByteArray((byte[])rhs);
My128BitValue result = v1 & v2;
return result.ToByteArray(); //implicit conversion
}
}
然后您可以从 SQL 运行bitwiseAnd128Bit
在两列上。
在这里阅读有关 CLR 的更多信息http://msdn.microsoft.com/en-us/library/w2kae45k(v=vs.90).aspx http://msdn.microsoft.com/en-us/library/w2kae45k(v=vs.90).aspx