Everyday Learning

Retrieve inserted row ID in SQL EmpTable: Column | Type --------|-------------------------------- ID | * Auto-incrementing primary key EmpName | Age | Query Sample: insert into Emp (Emp Name , Age ) values ( 'John' , 22 ) SELECT SCOPE_IDENTITY ();

Generate Unique ID in C#.Net and SqlServer. To Generate UniqueID in C#.Net: Guid.NewGuid() method will be useful to Achieve the task, It generates 36 character UniqueID. Example: Guid  guid =  Guid .NewGuid(); string  StrID = guid.ToString(); To Generate UniqueID in Sql Server 2008: newid() in build function will be useful to Achieve the task, It genrates 36 character UniqueID. Example: select newid() as UniqueID

SQL SERVER – Delete Duplicate Records DELETE FROM  Demo  WHERE  ID  NOT  IN  ( SELECT MAX ( ID )  FROM  Demo  GROUP BY  ColumnA ,  ColumnB )  The table must have identity column, which will be used to identify the duplicate records. Table in example is has ID as Identity Column and Columns which have duplicate data are ColumnA, CoumnB 

Improve SQL Server database design and performance http://www.dotnet-tricks.com/Tutorial/sqlserver/bM6H260812-Tips-to-improve-SQL-Server-performance.html

Implement  Google Charts in ASP.NET Web application Diffrent Type of Available Charts https://developers.google.com/chart/interactive/docs/gallery How to Implement Google Charts in App.net Web Application. This is one of the Simple and Easy to Understand Link i Found http://www.techipost.com/2011/02/24/google-charts-in-asp-net-web-application/