Structured Query Language (SQL) is a language for managing data in relational database management systems. This tag is for general SQL programming questions; it is not for Microsoft SQL Server, nor does it refer to specific dialects of SQL on its own.
This post is regarding how to replace first occurrence of one or more characters from database table Column. Suppose we have table named User with columns Id, Name, Phone Number as shown in the figure below. And contains records as shown in figure below: Now what I required to accomplish is replace the first ‘-‘ […]
Dear reader, Recently I noticed in my daily work that every time I logged in MS SQL I was required to select the database which I had to work on and this was regularly in use by me and this lead me to find the solution to change the default database selection after I log […]
HB Code – Line of business application for WPF This project is made available as open-source and hosted freely on www.codeplex.com. Prerequisites Object-oriented programming using C#.NET and LINQ. Nuget package usage. Basic knowledge of WPF application building such as input controls, container controls, triggers, styles, templates. Entity Framework, currently knowing any of versions of […]