Facebook
Welcome to Techsapphire

Clause

SQL Server UNION, INTERSECT and EXCEPT (MINUS) clauses

Union is to select all records from two table but common record only once. Select * from tbemp1UNIONSelect * from tbemp2 Inersect is to select common records from two tables. Select * from tbemp1INTERSECTSelect * from tbemp2 Except(Minus) is equivalent to oracle minus clause. Select records of table 1 which are not in table 2. Select * from […]

LINQ for Beginners

Topic covered are : WHERE clause in LINQ LEFT JOIN in LINQ INNER JOIN in LINQ GROUP BY in LINQ ORDER BY in LINA