string contains

Open specific tab on page load with JQuery UI

jQuery logo

I made a simple HTML page with JQuery UI tabs. But the customer asked to give URLs for each tab. I was a bit surprised with it, because I remember only how to make default tab on page load. You can do it with the syntax like this: $(“#tabs”).tabs( { selected: x  });  where ‘x’ […] Read more»

TypeScipt / Javascript

Concatenating NULL value columns in T-SQL

Figure 2. Concatenating after changing CONCAT_NULL_YIELDS_NULL to OFF

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»

SQL and databases

Popular Posts