The type of SQL joins are: cross join, inner join and outer join.
What is this cross join?
Monthly Archives: November 2016
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?
How run Oracle VM VirtualBox with Oracle Enterprise 12c database and start work
If You would like to start your work with Oracle database my proposition is Oracle VM VirtualBox
. This virtual machine contains Linux OS with enterprise edition Oracle 12c database.
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.
Create database model in DBDesigner
After install DBDesigner( I describe this process in my last post) You may run this application.
How install DBDesigner on Windows OS?
Go to http://fabforce.eu/dbdesigner4/
download open source tool for modelling and design databases. Download DBDesigner4.0.5.6_Setup
file.
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.
Sorted data in tables in SQL Server using COLLATE clause
The COLLATE
is a clause apply to the database, column or string expression, set collation for data.