How To Create New Database File In SQLite In Windows In this post we will learn How To Create New Database File In SQLite In Windows.In previous post we have discussed Introduction Of SQLite. Syntax: Open command prompt and then on SQLite directory run following command: SQLite3.exe hightechnology.db Example:
Author: Mandeep Singh
Categories
An Introduction Of SQLite
An Introduction Of SQLite In this post we will discuss about An Introduction Of SQLite.SQLite is a complete database system that has the advantage of requiring almost no setup. You just download a binary and work it like most other scripting languages.SQLite is an embedded relational database engine.SQLite is used in the Solaris 10 and Mac OS […]
Import Text File Using XP_CMDSHELL In SQL Server In this post we will learn how to Import Text File Using XP_CMDSHELL In SQL Server.There are several options available to import data from external sources to SQL Server. Such as Import & Export Wizard, BULK INSERT command, SSIS and OPENROWSET. Apart from this options you can also […]
SQL Server – When Will My Backup Finish? In this post we will learn When Will My Backup Finish? in SQL Server.The sys.dm_exec_requests is a great way to find out how long the BACKUP will take to complete. If you are doing a backup WITH STATS or by GUI, you will not need to use the DMV. But, […]