Maven Project in Netbeans 8 with JPA 2.1, Hibernate 5 and SQL Server 2012 database – create table and add data
Leave a reply
Category Archives: SQL Server
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.
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.
Using IS NULL or equal operator, IS NOT NULL or not equal operator?
The CASE expression in UPDATE statement in SQL Server 2012 – part 3
In this post You will be continue your adventure with CASE expression in SQL Server 2012.
ORDER BY clause – when may use and when don’t may use alias of column in SQL Server 2012
It is two situation in SQL Server 2012 when You may or don’t use alias of column in ORDER BY clause .
The CASE expression in ORDER BY clause in SQL Server 2012 – part 2
In this post You will be continue your adventure with CASE expression in SQL Server 2012.
Continue reading
The CASE expression in SELECT statement in SQL Server 2012 – part 1
The CASE expression is used in SELECT, UPDATE, DELETE statement
and in WHERE, IN, ORDER BY and HAVING clause.
Continue reading
Using alias of column in SQL query of SQL Server 2012
The SQL query in SQL Server may have alias of column. Using this alias out of name of column in query is possible only in ORDER BY clause. In this post I show You why?
The DISTINCT clause in agregate functions in T-SQL
The DISTINCT clause is used to return only distinct (different) values.
It is use often with SELECT statement. But it is not only one using this clause. You may use it either in agregate functions.
Creating new login in SQL Server througth T-SQL script
In my last post I show You how create login in server, in this I present how do it througth T-SQL query.
Creating administrator login for SQL Server 2012
In this topic step by step I show You how create system administrator login through SQL Server Management Studio.
UNIQUE clause and NULL in SQL Server 2012
In this topic You find out how work UNIQUE constraint for column with or without NOT NULL constraint.
The OFFSET-FETCH filter in T-SQL
The OFFSET-FETCH clause is filter using to choose sorted limited data from result set. It is similar to TOP clause, but with extra possibilities. It allow You to specify how many records want skip and how many records return.
TOP clause in T-SQL
Using TOP in T-SQL select given number of rows. It limits the rows returned in a query result set.
The LEAD and LAG functions in SQL Server 2012
Using ROW_NUMBER() function of Transact-SQL
ROW_NUMBER() in Transact-SQL returns sequential number of row in set of data from database, it returns bigint datatype as number.
What is faster in inserting data into database : PreparedStatement using batch or standard PreparedStatement in Java application?
What is better to use PreparedStatement with batch or without batch. I test both ways to connect by JDBC to database and get data from one table and insert into other.
How create in SQL Server empty table based on existing table filled data ?
In this topic I show You how create table of the same structure as table in your database but empty.
What is faster in getting data from database: Statement or PreparedStatement in Java application ?
What is better to use Statement or PreparedStatement. I test both objects to connect by JDBC to database and get data.
How use uniqueidentifier datatype in SQL Server ?
This post describe what is uniqueidentifier and how use it?
How check size of table in SQL Server ?
It is topic about way to check information about size of object, example table or database, and another information in SQL Server.
Default mapping datatypes from SQL Server to JDBC types and Java objects and ResultSet methods
In this post I show list of datatypes SQL Server and its equivalent datatypes in JDBC and Java objects with methods of ResultSet object.
How generate SQL script in SQL Server Management Studio to create database from SQL Server?
In SQL Server Management Studio is opportunity to generate script with SQL query creating all objects from any database.
Export data from SQL Server to CSV file.
In this topic I describe You how export data from SQL Server to text file or CSV.
How attach or detach database in SQL Server Management Studio?
Sometime we don’t want to show database in Databases node in SQL Server Management Studio, because we needn’t to change something in it. But main reason is move database from one to another server.
How add sample AdventureWorks2012 database for SQL Server 2012?
Go the http://msftdbprodsamples.codeplex.com/ website and click on icon with SQL Server 2012 DW.
SQL Server – GO command
GO is the command SQL Server, that inform server to send all T-SQL statements before GO to an instance SQL Server as one batch.
How get date and time parts in SQL Server 2012?
For get date and time parts in SQL Server 2012 are functions. Step by step I describe several of them.
How get current date and time from SQL Server ?
In this post I describe T-SQL functions get current date and time.
Date and time datatypes in SQL Server 2012
SQL Server 2012 provides following date and time datatypes:
date, time, datetime, datetime2, datetimeoffset, smalldatetime.
IDENTITY – autoincrement of column in SQL Server
In SQL Server autoincrement of column You may achieve by IDENTITY. Frequently it is column with primary key.
How get information about local server in SQL Server 2012?
Sometimes we must get information about our server. How to do it? I write about it in this post.
Steps for install Enterprise SQL Server 2012
In this post I show how install Enterprise SQL Server 2012.
How define PRIMARY KEY on column in the table? – SQL Server 2012
Almost all tables in databases have column with primary key. This column often has int datatype.
How add new column to the table in SQL Server Management?
Sometimes You would like to add column after created table. But this action may be blocked.
How resolve problem with don’t copy database files from server to paste them in the another folder
Recently I meet problem with copy database files from data folder in sql server and paste them in another folder in my PC.
