Regular expressions is one of the best ways to work with text. One popular task for Regexp is to get a part of word or expression.Let’s try to get first part from word “Heli-copter”, the part that before character “-“. Read more»
Tables with at least 20 rows are more readable when its rows look like stripes – even row in one color, odd one in another. Before jQuery we used to add class to each row of table, we made “<tr class=”even”> …</tr>” and “<tr class=”odd”> …</tr>”. Now it’s much easier to do using jQuery. Read more»
Using “System.Text.RegularExpressions” in C# you have a lot of abilities to work with text. One of practice of using System.Text.RegularExpressions is working with IP addresses. Read more»
There’re no associative arrays (hash) in common sense. There are Dictionaries for this. It’s a very good tool if you want to use link “key-value”. Using Dictionaries, keys and values can be different types. Read more»
Each time I forget how to add new line symbol to string. I decided to add to memories. Below how to add new line symbol to string in C#. string message = Label1.Text; message = message.Replace("<br />", System.Environment.NewLine); Read more»
It’s a little tutorial about how to get all duplicate records on namesakes example from your database table. For example, we have a table with columns Id, FullName, Birthdate and Phone. Using ‘GROUP BY’ and ‘HAVING’ we can select all namesakes. Read more»
Concatenating of string columns is not very simple task in T-SQL if you don’t know ANSI standart of it. According to ANSI standart of SQL, concatenating of NULL-value is NULL in the result. It’s not clearly for developer, but it is so. Let’s see some features for work with concatenating NULL-value columns. For example, I […] Read more»
This post is about which string functions there are in Transact-SQL. They allow to modify data you have, make custom queries to select records from database tables. To know them is very important for any developer – using string functions is very good way to decrease load from application server without adding it to SQL because […] Read more»
Another way for using conditions in Transact-SQL besides IF…ELSE is CASE operator. The syntax is some different from IF…ELSE but in some cases more readable. CASE also uses the word “THEN”. Read more»
On Microsoft.com you can download Microsoft® SQL Server® 2012 Express. It’s a free software for home use – education, tests or something like this. When you click “Download” link on a page http://www.microsoft.com/en-US/download/details.aspx?id=29062, you can see a list of versions for downloading. Which one to choose? Read more»
