Transactions in database
A transaction is a group of events that occur between any of the following events:Connecting to databaseDisconnecting to databaseCommitting changes to
Foreign Key (Self Reference) Constraint
Foreign Keys represent relationships between tables. A foreign key is a column (or a group of columns) whose values are derived from the primary key o
Establish connection in SqlServer.
Hi. In this blog, I will teach you that how to establish the connection to sql server in ado.net. This is first basic program through which you learn
Checkpoints in SqlServer
When we have the done operation on SQL SERVER that is not committed directly to the database. All operation must be logged in to Transaction Log files
Pivot tables in SqlServer 2005,2008
In this blog I will give you a small introductory knowledge on pivot table. One thing important about pivot keyword that it is only supported by SqlServer2005 and later not SqlServer 2000 or 7.0 or 6.5.
Inner Join in Sql Server
“INNER JOIN retrieves all the records from the left table and all the records from the right table.” It is similar to intersect operator but basic di
Union, Intersection and Except Operator in Sql Server
Union OperatorThe UNION operator is used to combine the result-set of two or more SELECT statements. Union Combines the results of two or more queries
Categorize SQL Commands in SQL Server
There are number of SQL Commands in SQl Server and we categorize these commands into subgroups.These subgroups are:Data Definition Language (DDL)Data
Trigger in MYSQL
A trigger in MySQL is a database object that is associated with a table. A trigger is fired, when a particular event occurs for the table.
Performance and Scalability characteristics of MySQL
MySQL has a unique storage engine architecture that makes it adaptable to most servers. MySQL meets the expectations of the most common ap
Using BLOB DataTypes in SQL Server
Blob Data TypeBLOB refers to large binary-valued image data. CLOB refers to large text data, and NCLOB refers to large ntext data. Blob data is a fi
Auto Increment id by Using Stored Procedure
In this blog I am going to explain that how to create a procedure which automatically increment id of table. For implementing this task I had created