This topic describes how write Java code of connection to SQLite Database in Netbeans.
This topic describes how add connection to SQLite database in Netbeans.
In this topic I describe how add SQLite JDBC driver to Netbeans.
SQLite delivers mechanism to import data from another source. One of this source is CSV file.
How create primary key with autoincrement column in SQLite ? I describe it step by step in this topic.
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.
It is first part about creating Android applications. In this post step by step is decribe how install SDK Android.
Sometimes You need change some values in UI in Your Swing application. Where from get these messages?
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.
How much bytes have integer datatype n C++? For diffrent platform it may be differ number.
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.