Category Archives: SQL Server
Create the Data Source in the Report Builder
How install Report Builder 3 for Reporting Services?
In this article I will explain you how install Report Builder 3 for Reporting Services.
Free Visual Studio 2017 edition – installation
Microsoft delivers free edition of Visual Studio 2017 – Community edition. This post focus on download this edition and installation process.
Continue reading
How configure Reporting Services of SQL Server 2017?
In the last post I show you how install Reporting Services. In this post I describe you how configure it.
How install Reporting Services for SQL Server 2017 Developer edition?
Maven Project in Netbeans 8 with JPA 2.1, Hibernate 5 and SQL Server 2012 database – create table and add data
OUTER JOIN in T-SQL in SQL Server 2012
In this topic I show You how work outer joins in T-SQL. It is three type of this joins:LEFT JOIN, RIGHT JOIN and FULL JOIN.
INNER JOIN in T-SQL in SQL Server 2012
The type of SQL joins are: cross join, inner join and outer join.
What is the INNER JOIN ?
CROSS JOIN in T-SQL in SQL Server 2012
The type of SQL joins are: cross join, inner join and outer join.
What is this cross join?
How display names of part date in your language?
Sometimes You display name of part of date example: name of day, name of day of week, month.
How convert numeric datatype to string by STR function?
How convert numeric datatype to string by STR function?
Substring functions: LEFT and RIGHT in SQL Server 2012
Sometimes instead of use substring function You may use LEFT or RIGHT function. Continue reading
Substring function in SQL Server 2012
T-SQL provides functions which operate on strings. One of this functions is SUBSTRING. This function returns new substring, get 3 parameters: string, start index, length of substring. Below You may see several examples with this function.
Using ASCII function or CHAR function in SQL Server 2012
The T-SQL provides ASCII function and CHAR function.
Using UNICODE function or NCHAR function in SQL Server 2012
The T-SQL provides UNICODE function and NCHAR function.
Concatenation strings get from columns of table in SQL Server 2012
How join strings comming from columns of table as one result string?
Collation of database and names of tables in SQL Server 2012 in diffrent statement
This post show how work creating and inserting, selecting data from tables with the same name of table but with diffrent size of letters in this name.
Create objects in SQL Server 2012 with appropriate collation
In this topic I show You how create in SQL Server object with any collation or change collation in existing object.
Compare characters in WHERE clause using COLLATE clause
The type of COLLATE is important in compare values with low-hight letter, accent letter or diacritical letter.
