tag
home / developersection / tag
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
Views in Database
A view can be thought of as either a virtual table or a stored query. Unless a view is indexed, its data is not stored in the database as a distinct o
Normalization and Denormalization in Database
Normalization is a method of break down complex table’s structure into simple table structure by using certain rules. http://www.min
SQL Server Transaction
Transactions group is a set of tasks into a single execution unit. Each transaction begins with a specific task and ends when all the task in the grou
What is Cursor in SQL Server?
A Cursor is a database object that represents a result set and is used to manipulate data row by row. When a cursor is opened, it is positioned on a row and that row is available for processing.
What is Join in SQLServer?
By using joins, you can retrieve data from two or more tables based on logical relationships between the tables. Joins indicate how Microsoft SQL Serv