System Databases in SQL Server
When you installed SQL Server several system databases are created automatically and these databases are master, model, msdb, tempdb and resource. The
Service Broker in Sql Server 2005, 2008
Service Broker in Sql Server 2005, 2008Service Broker is a message-queuing technology which allows developers to integrate SQL Server into distributed
HTTP Endpoints in SQL Server 2005, 2008
HTTP Endpoints in SQL Server 2005, 2008A HTTP Endpoint is a Sql Server object which is use by Sql Server to communicate over the network. It includes
Primary key
In this blog I will explain you that how to work with primary key in sql server. I will show some examples in whic you see different mechanism to create primary key.
Keys in database.
As we know that database uses tables to organize information. To maintain data integrity (that is data should be correct and in well formed) we use concept of keys.
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