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:
Views and Materialized Views in Oracle
Views and Materialized Views in OracleIt might be great confusion to the novice regarding views and Materialized views in SQL. Indeed, they are define
Simple popup panel in HTML
In this blog, I have described how to create a simple popup window or display page as popup window. There are simple CSS file and JavaScript that used for open model popup. Steps are given below.