In this article I will show you how to create Reporting services (SSRS) project and report step by step. This is a first step before we will be able to create report. To even start working with Reporting Services tool, we need to meet these requirements: Visual studio 2019 (or SSDT) – in case we… Read More »
SQL TRY CATCH command is designed to control code flow in case that error situation occurs (error handling). This construction consists of blocks. It is also possible to use transaction (more in article on Transactions). If an error occurs in the first block – TRY..END like that is activated code in CATCH..END block. TRY CATCH… Read More »
Email from MS landed in my inbox few days ago. It states that Power BI introduces new product called Power BI Premium valid since 2Q 2017. Hand in hand with this announcement comes another one of quite high importance. It will not be possible to share dashboards in the Power BI free product. Some Pro… Read More »
Operator UNION ALL in SQL makes it possible to unify 2 query results and does not remove duplicities in queries. Operator returns records of both queries with no regard for existing duplicities. UNION ALL belongs to group called SET operators together with UNION, EXCEPT, INTERSECT SQL UNION ALL Syntax SELECT Column FROM dbo.Table WHERE Condition UNION… Read More »
UNION operator makes it possible to connect 2 results of query and remove all existing duplicities in them. In other words, operator actually performs DISTINCT (like SELECT DISTINCT) in final unification of records. SQL UNION Syntax SELECT Column FROM dbo.Table WHERE Condition UNION SELECT Column FROM dbo.Table WHERE Condition; Syntax is same as… Read More »
SUBSTRING function is used in sql to select part of text string in text. This function belongs to the group of text functions – string functions. I created a big summary of T-SQL text functions – you can find it here. SQL SUBSTRING Syntax SELECT SUBSTRING(text, <start position of the text character>, <the number of… Read More »
T-SQL command IF is used to control flow of code mainly in operations where we somehow influence db (DDL, DML operations) – for example procedures. You can mix it up with CASE command quite simply. The common mistake is that we try to push sql IF into SELECT clause. Query in which IF is used… Read More »
This article follows post in which I offered overview of Data types in SQL Server (more in SQL Data types – Overview ). You can find list of all system data types in it. We can now focus on another category from mentioned overview of t-sql Date and time data types. Date data types specification… Read More »
I will follow the previous article on Data types. I will go through numeral data types and their properties. Thanks to correct data type selection you may be able to save disk storage. You only need to think about range of values of column which you want to represent. Then just select the correct type.… Read More »
All columns, variables or terms in SQL Server have their defined data types. These data types define of what type are the values which can be contained in given column or other logical object. Every time you try to create a table , variable or term, a definition defining sql data types is required. Wrong… Read More »