No Image

Azure DevOps Vs GitHub

January 3, 2021 admin 0

Azure DevOps Services :- — A tool in the “Project Management” category — Service for teams to share code, track work, and ship software. — […]

No Image

*ngFor structural directive

January 3, 2021 admin 0

A built-in template directive that makes it easy to iterate over collection, array, list and create a template for each item. <select class=”form-group”> <option value=””> […]

No Image

Angular Interpolation

January 3, 2021 admin 0

Process of displaying a component property in the respective view template is called Interpolation. By Using Interpolation, we can bind any type of property into […]

Linq Filter

January 3, 2021 admin 0

Linq Filters | Distinct, Linq Contains Distinct ———– result = context.users .Select(x => new User{ user_name= x.user_name }).Distinct().ToList();

Linq Format Values

January 3, 2021 admin 0

Currency Conversion result = context.payments .Select(x => new Payment { id = x.payment_id, paid_amount = x.paid_amount != null ? x.paid_amount.Value.ToString(“N2”) : “0.00” }).ToList(); Date Conversion […]

Linq Order

January 3, 2021 admin 0

Order By Single Column var result = context.users .Where(x => x.is_active) .Select(x => new User { id = x.user_id, name = x.firstname, address = x.address, […]

Cursor- Sql Server

List Stored Procedure In Sql Server

January 3, 2021 admin 0

1. list of all Stored Procedure Modified in last N Days ———————————————————————— SELECT name FROM sys.objects WHERE type = ”P” AND DATEDIFF(D,modify_date, GETDATE()) < 10 […]

Cursor- Sql Server

Date Calculation in Sql Server

November 20, 2020 admin 0

Date Calculation in Sql Server Compute Total Duration in Seconds –Total number of seconds between two dates select *, DateDiff(second, StartDate, EndDate) as TotalSeconds  from Bookings ID          StartDate                    EndDate                    TotalSeconds 1           2020–01–01 06:34:12.000      2020–01–01 12:45:34.000    22282 2           2020–01–02 09:23:08.000      2020–01–02 17:05:37.000    27749 3           2020–01–03 16:34:12.000      2020–01–03 16:55:18.000    1266 4           2020–01–04 11:02:00.000      2020–01–04 14:53:21.000    13881 5           2020–01–05 07:52:55.000      2020–01–05 09:08:48.000    4553 6           2020–01–06 19:59:11.000      2020–01–07 01:23:11.000    19440 7           2020–01–07 03:12:23.000      2020–01–07 20:02:25.000    60602     Convert Above Duration […]