exception of type 'system.outofmemoryexception' was thrown Aras innovator

Root cause: Your AML might returning more data
Solution:
-change AML query, try to avoid select="*", give always select="id,item_number"

Visual Studio compare SQL server table Data Compare

Visual Studio => Tools => SQL Server => New Data Comparison ...
In the new window, Under "Source Database", Click on "Select Connection..."
Enter SQL DB Server name
Select Database
Click on Connect

In the new window, Under "Target Database", Click on "Select Connection..."
Enter SQL DB Server name
Select Database
Click on Connect

Check All check boxes

Click Next

Select Tables which you want to compare
Finish
You will see data difference b/w 2 DBs

Visual Studio - How to Compare Database Schema

Open Visual studio
Tools-->SQL Server-->New Schema Comparison..
You will see a page, where you can select source database using option "Select Source..."
New window will open -->Select "Database"
Click on Select Connection..
Enter Server: SQLLocalhost
Enter Authentication, user name, password
Select "Database Name" Ex: DB1
Click Ok

In the Visual studio page, select target database using option "Select Target..."
New window will open -->Select "Database"
Click on Select Connection..
Enter Server: SQLLocalhost
Enter Authentication, user name, password
Select "Database Name" Ex: DB2
Click Ok

Click on "Compare"

Excel Find all the data which start with XYZ, till next number

Input: Column A-->
ABC-2123-XYZ-023111-Test-2-BOX-US-ZAW

Find all the data which start with XYZ, till next number
Formula:
=MID(A1,FIND("-XYZ",A1)+1,10)

Copy SQL tables in to new data base

I have a SQL DB name Test
table names are Tbl_1, Tbl_2
Now i would like to create new DB with same tables from Test

Create new DB Test_Copy
Create new query from Test_Copy DB
Now run below query to create tables with data

 select * into [dbo].[Tbl_1] from [Test].[dbo].[Tbl_1]
 select * into [dbo].[Tbl_2] from [Test].[dbo].[Tbl_2]

Excel find duplicate rows

=countif(M:M, M2)

if you get 1 mean, row is coming 1 time, if it is 2,3,4.... mean, duplicate records are there

ASP.net MVC WEB API Angular 2

http://ecollabro.codeplex.com/SourceControl/latest
http://webapiclientgen.codeplex.com/SourceControl/latest

WEB API, Angular 2