tag
home / developersection / tag
Magic Table in SQL Server
In SQL server magic table is nothing more than an internal table which is created by the SQL server to recover recently inserted, deleted and updated data into SQL server database.
Working With XML Data in Sql Server.
XML has been widely recognized as a platform-independent format for data representation. It is useful for exchanging information among loosely coupled
Sub Query in Sqlserver.
A subquery defined as a select query that returns a single value and is nested inside a select, insert, delete or update command. We will use sub quer
View in SQL Server
Views can be considered as virtual table. Generally speaking, a table has a set of definition, and it physically stores the data. A view also has a
SQL Stored Procedure
Stored procedure is an important concept which is used for access or modifies data into database. A stored procedure is a group of Transact-SQL state
SQL Function
Functions are compact pieces of Transact SQL code, which can accept parameters, and return either a value, or a table. They are saved as individual wo
Index in Sql Server
Index is most important concept of SQL Server database to increase performance of retrieving data from database. Indexes speed up the querying proc
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.