Abundant Code

  • C#
  • C++
  • Elastic Search
  • Entity Framework
  • F#
  • JavaScript
  • ASP.NET
  • C
  • Java
  • SQL Server
  • Assembly Lang
Home » Query

Using NOT operator to inverse the condition in SQL Server

August 17, 2016 by AbundantCode Leave a Comment

Imagine a scenario where you want to retreive records that you dont want. You can use the NOT operator to reverse the search condition. For example , You want to get all the departments having the GroupName other than ‘Research and Development’. The other way of getting the same result is using the != in […]

Filed Under: SQL Server Tagged With: How to, Query, SQL Server, tips, tricks

Alias Names for Tables in SQL Query

August 16, 2016 by AbundantCode Leave a Comment

There are times when you write query and end up qualifying the columns references by indicating the table name. For example , In the above query , the Department table is referred in the GroupName and Name column. Instead of mentioning the table table , we could provide a shortname or alias name for the […]

Filed Under: SQL Server Tagged With: How to, Query, SQL Server, tips, tricks

How to get specific columns from a Table in SQL Query ?

August 15, 2016 by AbundantCode Leave a Comment

If you want to get the data from the specific columns from a table in your database , you can specify them in the query. For example, This would return the data of all the columns available in the Department table. If you want to get the data of the specific columns from the Department […]

Filed Under: SQL Server Tagged With: How to, Query, SQL Server, tips, tricks

Example of deferred execution of LINQ Query in C# .NET

December 6, 2013 by AbundantCode Leave a Comment

Below is a sample code snippet that demonstrates the deferred execution of LINQ Query in C#. Example of deferred execution of LINQ Query in C# .NET The Output of the above program is

Filed Under: C# Tagged With: .NET, C#, deferred, execution, LINQ, Query

Returning Dictionary from LINQ Query in C#

July 29, 2013 by AbundantCode 1 Comment

Below is a sample source code demonstrating how to return Dictionary of<int, string> from the LINQ Query result. Returning Dictionary from LINQ Query in C#

Filed Under: C# Tagged With: C#, Dictionary, LINQ, Query, tutorials

How to Get the Max Value from a List of Integer using LINQ Query in C#?

July 29, 2013 by AbundantCode 4 Comments

One of the easiest way to get the Max value from a List of Integer in C# is to use LINQ extension method. The LINQ in C# provide the Max method which can be used to retrieve the Max Value from the List. How to Get the Max Value from a List of Integer using […]

Filed Under: C# Tagged With: C#, LINQ, List, Max Value, Query

How to Get the First Element from LINQ Query in C#?

July 22, 2013 by AbundantCode Leave a Comment

Below is a sample source code demonstrating How to Get the First Element from LINQ Query in C#? How to Get the First Element from LINQ Query in C#?

Filed Under: C# Tagged With: C#, First Element, How to, LINQ, Query

RSS
Facebook
fb-share-icon
Twitter
Visit Us
Follow Me
Tweet

Recent Posts

  • Collapsible links for subcategories in Docusaurus Sidebar
  • Python Program to Print Fibonacci Series
  • Python Program to Generate Multiplication Table
  • Python Program to Find the Factorial of a Number
  • Python Program to Print Prime Numbers in a Given Interval

Categories

Tags

.NET App Array ASP.NET ASP.NET MVC Assembly Language C# C# programs c lab programs Collection convert C program csharp database Example F# guide How to How to in Java integer Java Javascript Lab programs Lambda LINQ List Python lab programs Python programs SIC/XE SQL Server string tips tricks tutorial tutorials UWP visual studio 2015 Windows Windows 8 Windows 10 Windows Phone Windows Phone 8 Windows Phone 8.1 wp8 XAML

Blog Stats

  • 8,734,037 hits

Archives

Top Posts & Pages

  • System Software – SIC/XE Program to find the maximum element in the array and store result in MAX
  • How to Convert a Stream to Byte Array in C# 4.0 ?
  • How to open display settings from command line in Windows 10 ?
  • How to Extract number from a string using C# ?
  • How to Quickly Delete All Rows in a Table in Entity Framework?
  • Json.NET & VB.NET - How to Serialize an Object ?
  • System Software – SIC/XE Program to arrange an array of 100 words in ascending order
  • Json.NET & VB.NET - How to Deserialize an Object ?
  • System Software - SIC program to set 100 elements of array to Zero
  • How to retrieve the URL of the current Page in ASP.NET MVC 4 Controller ?

Categories

  • Android
  • Angular 2
  • ASP.NET
  • Assembly Language
  • C
  • C#
  • C++
  • Elastic Search
  • Entity Framework
  • Excel
  • F#
  • HTML
  • Interview Questions
  • Java
  • JavaScript
  • jQuery
  • Microsoft Office
  • MySQL
  • NETWORK
  • News
  • PHP
  • popular
  • PowerShell
  • Python
  • Ruby
  • SharePoint
  • SQL Server
  • SQL Server
  • Unix
  • VB.NET
  • Visual Studio
  • WebAPI
  • Windows
  • Windows Azure
  • Windows Forms
  • XAML

Top Posts & Pages

  • System Software – SIC/XE Program to find the maximum element in the array and store result in MAX
  • How to Convert a Stream to Byte Array in C# 4.0 ?
  • How to open display settings from command line in Windows 10 ?
  • How to Extract number from a string using C# ?
  • How to Quickly Delete All Rows in a Table in Entity Framework?
  • Json.NET & VB.NET - How to Serialize an Object ?
  • System Software – SIC/XE Program to arrange an array of 100 words in ascending order
  • Json.NET & VB.NET - How to Deserialize an Object ?
  • System Software - SIC program to set 100 elements of array to Zero
  • How to retrieve the URL of the current Page in ASP.NET MVC 4 Controller ?

Recent Posts

  • Collapsible links for subcategories in Docusaurus Sidebar
  • Python Program to Print Fibonacci Series
  • Python Program to Generate Multiplication Table
  • Python Program to Find the Factorial of a Number
  • Python Program to Print Prime Numbers in a Given Interval
  • Python Program to Check Prime Number
  • Python Program to Find the Largest Value Among Three Numbers
  • Python Program to Check If a Given Year is Leap Year
  • Python Program to Check if a Number is Odd or Even
  • Python Program to Check if a Number is Positive, Negative or Zero

Tags

.NET App Array ASP.NET ASP.NET MVC Assembly Language C# C# programs c lab programs Collection convert C program csharp database Example F# guide How to How to in Java integer Java Javascript Lab programs Lambda LINQ List Python lab programs Python programs SIC/XE SQL Server string tips tricks tutorial tutorials UWP visual studio 2015 Windows Windows 8 Windows 10 Windows Phone Windows Phone 8 Windows Phone 8.1 wp8 XAML