Many times when working with date and times in select, where – the data doesn’t show up in the result window or is not in the format we are looking for. SQL server provides with some build in functions to format the date and time string for you. When using date time the most common […]
For Part I please refer link Part II – please refer link One we have referenced / loaded JQuery (as mentioned in Part II) either using a local copy or CDN, the next thing is to start using JQuery. the most important function of jQuery that is used a lot and we all would be […]
For Part I Please click following link Considering you have are already downloaded JQuery files (see note below) from JQuery website or you have Microsoft or Google CDN (Content Distribution Networks) link (more on this below in this post). The first thing you need to do for using JQuery is setting up JQuery reference in the […]
What is Entity Framework? Definition (Microsoft): The Microsoft ADO.NET Entity Framework is an Object/Relational Mapping (ORM) framework that enables developers to work with relational data as domain-specific objects, eliminating the need for most of the data access plumbing code that developers usually need to write. Using the Entity Framework, developers issue queries using LINQ, then […]
STUFF() Function – Transact SQL The STUFF function deletes a specified length of characters and inserts a designated string at the specified starting point. Important note: STUFF function has a limitation if 4000 characters. The syntax is as follows: STUFF ( character_expression, start, length, character_expression ) character_expression: argument of this function is the character expression […]
In this article, we will understand how to work with strings in C#, use string class in C# and finally used learn how to use the String Builder class in C#. In C# strings are created by enclosing a series of characters in double quotation marks, these series of characters can be letters, numbers, and […]
Design Pattern – Singleton In this blog we discuss and learn about the easy design pattern of all the design patterns – the Singleton pattern. This article is an attempt to provide the new developers / readers with some basic understanding about singleton pattern and its implementation in my words. Singleton pattern when implemented provides […]
The Raspberry Pi 3 is the third-generation Model B. It shares the same design as its predecessor Raspberry Pi 2. Its is different in terms of processor, it’s, speed and few more things.