category
home / developersection / category
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
Stored Procedure in SQL Server
In this blog, I’m trying to explain the stored procedure in sql server. A stored procedure is aset of SQL commandsthat has beencompiledand stored on
Keys in SQL
In this blog, I’m explaining the keys in sql and how to create it.Primary KeyA Primary Key is a column which has unique values in the column. A primar
Create Table Statement in SQL
In this blog, I’m trying to explain the create table statement in sql. You need tables in database to store data. Create Table statement is used to c
Difference between GRANT and WITH GRANT in SQL Server 2008 R2
This blog provides an overview of the difference between GRANT and WITH GRANT using SQL Server 2008 R2.GRANT and WITH GRANT: The difference between
Difference between char, varchar and nvarchar in sql server
char, varchar and nvarchar are SQL Server data type that used for allocated memory in storage device. But there is little difference between them which described below: