tag
home / developersection / tag
AND and OR Operators of SQLite
In this blog we will discuss about SQLite AND and OR operators are that are used to execute multiple conditions to narrow down the selected data in an SQLite statement. Both of these two operators known as conjunctive operators.
SQLite - DETACH DATABASE COMMAND
The DETACH DATABASE statement is used to detach and dissociate a named database from a database connection which was previously attached using ATTACH statement.
CURSOR in SQL Server
In this blog describe the concept of cursor in sql server and how to create cursor in sql server, types of cursor. Here, I’m trying to demonstrate the good examples of cursors.
Creating, Inserting, Updating and Deleting in SQLite
In this blog, I’m explaining how to create and use the sqlite database in our application. IntroductionSQLite is a relational database management sy
Locks in SQL Server
In this article, I’m explaining the locks in sql server and its types. Locking helps in providing concurrency within the database. Without locking, S
Checkpoint in SQL Server
In this blog, I’m explaining the checkpoint in sql server. The SQL Server Database Engine automatically executes the CHECKPOINT command to write all
Views in SQL Server
In this blog, I’m trying to explain the views in sql server and how to create it. A view can be thought of as either a virtual table or a stored quer
User Defined Function in SQL Server
In this blog, I’m explaining user defined functions in sql server. There are three Types of User Defined Functions in Sql Server:ScalarInline Table-V
Transaction in SQL Server
In this blog, I’m trying to explain the transaction in sql server. A transaction is a unit of work in which either all the statements are processed s
Rules in SQL Server
In this blog, I’m explaining the rules in sql server and how to create it.Rules enforce domain integrity by providing sophisticated checking of the va
Default Constraint in SQL Server
In this blog, I’m explaining the default constraint in sql server and how to create it. Defaults are the objects that can be bound to one or more col