To get the row number in SQL2000.

SELECT *,(SELECT COUNT(*) FROM Mas_Company

e2 WHERE e2.Company_Code <= e.Company_Code) AS 'rownumber', Mas_Company.*, Company_Code AS Expr1, Company_Name AS Expr2, Company_SName AS Expr3, Company_Add1 AS Expr4,

Company_Add2 AS Expr5, Company_City AS Expr6, Company_Pincode AS Expr7, Company_ph_no AS Expr8, Company_Active_Flag AS Expr9

FROM Mas_Company e

Comments

Task Parallel Library (TPL) and Akka.NET: Differences

Task Parallel Library (TPL) and Akka.NET are both powerful tools in the .NET ecosystem for handling parallelism and concurrency, but they serve different purposes and use different models of computation. Here are some key differences:s 1. Actor Model vs Task-Based Model: Akka.NET is built around the actor model, where actors are the fundamental units of computation and they communicate by exchanging messages. TPL, on the other hand, is task-based. It's designed to make developers more productive by simplifying the process of adding parallelism and concurrency to applications. TPL uses tasks (which are independently executing work units) and provides various ways to control and coordinate them. 2. Fault Tolerance: One of the key features of Akka.NET is its built-in fault tolerance. It has a "let-it-crash" philosophy, where the system is designed to self-heal from errors. If an actor fails, its parent actor can decide on the supervision strategy: either to resta

Learning ASP.NET MVC

ASP.NET MVC Learning 1 : Introduction ASP.NET MVC Learning 2 : Routing Basic ASP.NET MVC Learning 3 : Global.asax.cs ASP.NET MVC Learning 4 : Session Handling

Extension Methods - Advanced

Here we will see how can we use the Extension Methods in advanced manner in other types Imagine you often need to retrieve items from a List based on a custom criterion that the built-in LINQ methods don't cover. Extension Methods for Lists: Filtering based on Custom Criteria And the output would be Extending Enums: Displaying Descriptive Strings Output: Extending DateTime: Calculating Age Output: The code samples can be found at https://github.com/oneananda/C_Sharp_Examples/tree/main/ExtensionMethods

OneAnanda (Code Center)

Search This Blog