insert into Students
select list.Id, list.[Name]
from
(values
(1,N'Вася'),
(2,N'Петя'),
(3,N'Женя'),
(4,N'Коля'),
(5,N'Настя'),
(6,N'Аристарх'),
(7,N'Никодим')
) list (Id, [Name])
left join Students s on s.Id = list.Id
where s.Id IS NULLSpecifies that data read by any statement in a transaction will be the transactionally consistent version of the data that existed at the start of the transaction. The transaction can only recognize data modifications that were committed before the start of the transaction. Data modifications made by other transactions after the start of the current transaction are not visible to statements executing in the current transaction. The effect is as if the statements in a transaction get a snapshot of the committed data as it existed at the start of the transaction.
Tip: You can open any file by its name when you type ⌘P (Windows, Linux Ctrl+P) (Quick Open).
class Program
{
private static readonly Range[] ExistedRanges = {
new Range(0, 2),
new Range(5.01f, 7),
new Range(7.01f, 9)
};
public static bool IsValidRange(Range range)
{
return !ExistedRanges.Any(o => o.IsCross(range));
}
static void Main()
{
Console.WriteLine(IsValidRange(new Range(2.01f, 5)));
Console.WriteLine(IsValidRange(new Range(11, 13)));
Console.WriteLine(IsValidRange(new Range(1, 3)));
Console.WriteLine(IsValidRange(new Range(3, 10)));
Console.ReadKey();
}
}
public struct Range
{
public readonly float Start;
public readonly float End;
public Range(float start, float end)
{
Start = start;
End = end;
}
public bool IsCross(Range other)
{
return Math.Min(Math.Max(Start, End), Math.Max(other.Start, other.End)) >=
Math.Max(Math.Min(Start, End), Math.Min(other.Start, other.End));
}
}