1. Selecting all the values from a table for a particular date This is a very popular question and people sometimes answer that you need to use between. There is a problem with between if you happen to have a Read More …
Category: Programming
Part 3: Logic and Conditionals
Boolean Expressions A boolean expression is any expression that evaluates to, or returns, a boolean value. Boolean Type The bool data type can be either true or false and is based on the concept that the validity of all logical statements must be either true or false. Booleans Read More …
Part 2: Data Types and Variables
Write Line The Console.WriteLine() method is used to print text to the console. It can also be used to print other data types and values stored in variables. Variables and Types In C#, a variable is a way to store data in Read More …
Part 1: Hello World
Read Line The Console.ReadLine() method is used to get user input. The user input can be stored in a variable. This method can also be used to prompt the user to press enter on the keyboard. C C# is a general-purpose, type-safe, object-oriented programming Read More …
CSS Cheat Sheet
Selectors Universal Selector * {} ID Selector #id {} Class Selector.class {} Type Selectorh1, h2 ,h3 {} Adjacent Sibling Selectorh1 + p {} Child Selectorul > li {} General Sibling Selectorh1 ~ p {} Descendant Selectorp a {} Attribute Selectordiv[attribute=”SomeValue”] Read More …
HTML Cheat Sheet
This cheat sheet – or HTML code quick reference – lists the common HTML tags and their attributes, grouped into relevant sections in an easy-to-read format. Basic HTML Structure Common Tags for Blogs<h?> heading </h?>Heading (h1 for largest to h6 Read More …
Introduction to HTML and CSS
This tutorial teaches you the basics of HTML and how to build your first website. That means how to layout an HTML page, how to add text and images, how to add headings and text formatting, and how to use tables. Read More …
Window Function In SQL Server
Introduction to Window functions Window functions operate on a set of rows and return a single aggregated value for each row. The term Window describes the set of rows in the database on which the function will operate. Window (or Read More …
Error :4127 – At least one of the arguments to COALESCE must be a typed NULL
This error message is shipped with SQL Server 2005 and it occurs due to one of the nice functions namely COALESCE . Lets discus the cause and resolution for this error message. Let me explain this error in detail : Message Number: 4127 Severity Read More …
Data Conversion
In this article, we will convert text to number in multiple versions of SQL Server and will see the difference. I will use four different Data conversion functions (Convert, Cast, Try_Convert & Try_Cast) to convert Text to Number. Let me explain this with simple examples. Read More …