In this post I show list of datatypes SQL Server and its equivalent datatypes in JDBC and Java objects with methods of ResultSet object.
In SQL Server Management Studio is opportunity to generate script with SQL query creating all objects from any database.
In this topic I describe You how export data from SQL Server to text file or CSV.
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.
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.
For get date and time parts in SQL Server 2012 are functions. Step by step I describe several of them.
In this post I describe T-SQL functions get current date and time.
SQL Server 2012 provides following date and time datatypes:
date, time, datetime, datetime2, datetimeoffset, smalldatetime.
In SQL Server autoincrement of column You may achieve by
IDENTITY. Frequently it is column with primary key.
Sometimes we must get information about our server. How to do it? I write about it in this post.
In this post I show how install
Enterprise SQL Server 2012.
Almost all tables in databases have column with primary key. This column often has int datatype.
Sometimes You would like to add column after created table. But this action may be blocked.
Recently I meet problem with copy database files from data folder in sql server and paste them in another folder in my PC.